|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Can't get SELECT FROM INTO to work
Neither works for me in VB6. Does VB accept compund statements?
conn.Execute ("Create Table NewTable SELECT * FROM GameInfo") [syntax error in Create Table] conn.Execute "SELECT * FROM GameInfo INTO NewTable" [syntax error in from clause] |
|
#2
|
||||
|
||||
|
It has to be valid sql syntax.
The database you are using determines what is valid and what is not. Not knowing what kind of database you are working with all I can do is suggest another style of statement instead of what you have done. i.e. create table NewTable as (select * from GameInfo) |
|
#3
|
|||
|
|||
|
Sorry all, I am using VB6sp5 MS access/jet 4.0, windows XP home
|
|
#4
|
||||
|
||||
|
as long as you can perform the query in your access client, then you can do the same thing with vb.
|
![]() |
| Viewing: Dev Shed Forums > Programming Languages - More > Visual Basic Programming > Can't get SELECT FROM INTO to work |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|