-
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
-
Feb 28th, 2013, 11:44 PM
#2
Re: Help me mysql query
What is this ???
Can't say I have ever saw that in a query before nor do I see it in any SQL references
Your question would seem better suited for the database section as it really has nothing to do with VB
Edit: Now I see that you did start a thread in the DB section as well as post this same question in 2 other existing threads.
You should start only one thread per question and do so in the correct area and do not jump in to others threads with your question especially if you already have your own thread on it.
Last edited by DataMiser; Feb 28th, 2013 at 11:49 PM.
-
Mar 1st, 2013, 06:08 AM
#3
Re: Is mysql support shape command ???
Duplicate threads merged - please post each question (or variation of it) only once.
I have also deleted the copies you posted to other peoples threads - please do not post your own questions in existing threads.
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
|