Click here to Skip to main content
16,005,222 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: ACCESS PROGRAMMING Pin
KaptinKrunch30-Nov-05 6:50
KaptinKrunch30-Nov-05 6:50 
GeneralRe: ACCESS PROGRAMMING Pin
Jkkenzie1-Dec-05 6:53
Jkkenzie1-Dec-05 6:53 
AnswerRe: ACCESS PROGRAMMING Pin
Ray Cassick30-Nov-05 9:06
Ray Cassick30-Nov-05 9:06 
GeneralRe: ACCESS PROGRAMMING Pin
Jkkenzie1-Dec-05 6:07
Jkkenzie1-Dec-05 6:07 
Questionbit operations Pin
Marc Soleda30-Nov-05 4:22
Marc Soleda30-Nov-05 4:22 
AnswerRe: bit operations Pin
Dave Kreskowiak30-Nov-05 5:11
mveDave Kreskowiak30-Nov-05 5:11 
GeneralRe: bit operations Pin
jo0ls30-Nov-05 6:56
jo0ls30-Nov-05 6:56 
QuestionInvalid SQL Statement Pin
sarah_chandran30-Nov-05 1:50
sarah_chandran30-Nov-05 1:50 
Hi,
Can i create tables from vb6?
I tried it but i get this error if i use the provider- Jet 3.51 (for MS-Access) , if i use Jet 4.0 i do not get this error.
So does the syntax change when i use Jet 3.51?

ERROR:

"Invalid SQL statement, expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT' ,
or 'UPDATE'."

Alter,Update,Delete,Insert etc. work in Jet 3.51, only Create gives this error.

Can anyone tell me the syntax for create table in vb6 using Provider 3.51?

Right now my code reads like this;

sSql="CREATE TABLE Tab1(ID Number,Age Number)"

gCon.Execute sSql

Thanks in advance,
Sarah



-- modified at 23:57 Wednesday 30th November, 2005
AnswerRe: Invalid SQL Statement Pin
KaptinKrunch30-Nov-05 3:01
KaptinKrunch30-Nov-05 3:01 
GeneralRe: Invalid SQL Statement Pin
sarah_chandran30-Nov-05 18:00
sarah_chandran30-Nov-05 18:00 
GeneralRe: Invalid SQL Statement Pin
Scott Serl1-Dec-05 7:03
Scott Serl1-Dec-05 7:03 
AnswerRe: Invalid SQL Statement Pin
Scott Serl30-Nov-05 7:22
Scott Serl30-Nov-05 7:22 
GeneralRe: Invalid SQL Statement Pin
sarah_chandran30-Nov-05 18:01
sarah_chandran30-Nov-05 18:01 
GeneralRe: Invalid SQL Statement Pin
KaptinKrunch1-Dec-05 17:42
KaptinKrunch1-Dec-05 17:42 
GeneralRe: Invalid SQL Statement Pin
sarah_chandran6-Dec-05 1:11
sarah_chandran6-Dec-05 1:11 
QuestionVisual Basic IE control JAVA Script Errors cant be surpressed! Pin
dmachine30-Nov-05 1:10
dmachine30-Nov-05 1:10 
AnswerRe: Visual Basic IE control JAVA Script Errors cant be surpressed! Pin
dmachine30-Nov-05 1:23
dmachine30-Nov-05 1:23 
GeneralRe: Visual Basic IE control JAVA Script Errors cant be surpressed! Pin
Dave Kreskowiak30-Nov-05 4:59
mveDave Kreskowiak30-Nov-05 4:59 
GeneralRe: Visual Basic IE control JAVA Script Errors cant be surpressed! Pin
dmachine1-Dec-05 15:35
dmachine1-Dec-05 15:35 
GeneralRe: Visual Basic IE control JAVA Script Errors cant be surpressed! Pin
KaptinKrunch1-Dec-05 17:48
KaptinKrunch1-Dec-05 17:48 
GeneralRe: Visual Basic IE control JAVA Script Errors cant be surpressed! Pin
Dave Kreskowiak2-Dec-05 2:47
mveDave Kreskowiak2-Dec-05 2:47 
GeneralRe: Visual Basic IE control JAVA Script Errors cant be surpressed! Pin
dmachine2-Dec-05 6:43
dmachine2-Dec-05 6:43 
QuestionHow to create thread in VB Pin
Sushmadm30-Nov-05 0:13
Sushmadm30-Nov-05 0:13 
AnswerRe: How to create thread in VB Pin
Ray Cassick30-Nov-05 9:09
Ray Cassick30-Nov-05 9:09 
AnswerRe: How to create thread in VB Pin
Briga30-Nov-05 21:26
Briga30-Nov-05 21:26 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.