Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Insert Into Access table
Message
From
04/06/2002 09:24:22
Plamen Ivanov
J.E.I.
Varna, Bulgaria
 
 
To
04/06/2002 08:44:58
Ger Connolly
Icm Unicomp
Dublin, Ireland
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Insert Into Access table
Miscellaneous
Thread ID:
00664348
Message ID:
00664417
Views:
30
OK, I forgot to remove the table prefixes:

SQLEXEC(lnAccess,"INSERT INTO mytable (no, batch, filename) VALUES ('" + tmpdata.no + "', '" + tmpdata.batch + "', '" + tmpdata.filename + "')")

Plamen Ivanov
MCSD .NET Early Achiever and MCAD .NET Charter Member (VB .NET/SQL Server 2000)
MCSD (VB 6.0/SQL Server 2000)
VB (.NET) - what other language do you need in the whole Universe?...

Previous
Reply
Map
View

Click here to load this message in the networking platform