Computing.Net > Forums > Database > Error in VB TRANSFORM code

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Error in VB TRANSFORM code

Reply to Message Icon

Name: Eule713
Date: October 18, 2006 at 01:06:03 Pacific
OS: MS XP SP1
CPU/Ram: P4 640 / 1 Gb
Product: Home Brand
Comment:

I try to include MS Access 2003 crosstab query design code (internally generated SQL) into a VB6 module. Here is the ColumnHeadings definition which is the last line of the 'TRANSFORM' statement.

"PIVOT Format([Date],"mmm") In ("Jul","Aug");"

I get an 'Expected: end of statement' error at "mmm" which I think is due to the repeated use of " at the beginning of the line and at the month definition.

How do I get around this? Regards, Wilfried



Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Database Forum Home


Sponsored links

Ads by Google


Results for: Error in VB TRANSFORM code

Reading a .bas file in VB 2005 www.computing.net/answers/dbase/reading-a-bas-file-in-vb-2005/467.html

Error in Foxpro 2.5 Application running www.computing.net/answers/dbase/error-in-foxpro-25-application-running/634.html

How To Store Vedio File in Database www.computing.net/answers/dbase/how-to-store-vedio-file-in-database/706.html