|
-
Feb 28th, 2013, 09:49 PM
#1
Thread Starter
Member
Is mysql support shape command ???
HI I'AM USING SHAPE COMMAND IN MYSQL THEN I GOT SYNTAX ERROR,.... IS MYSQL SUPPORT SHAPE COMMAND ? HERE IS MY CODE
sql = "SHAPE { select school_year,student_no,concat(yearlevel,'-',section) as ylsec from assessedstudent_1_view } as cat "
sql = sql & " APPEND ({ select concat(lastname,' ',first_name,' ',mid_name) as fullname,concat(yearlevel,'-',section) as ylsec from assessedstudent_1_view}"
sql = sql & " Relate ylsec to ylsec)"
I'AM USING VB6 AND MYSQL 
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|