A type mismatch means that either of your RB variables (network or
server) is not defined as a string.
These need to be strings if you are going to use the simple syntax
you have written here.
I often find it easier to not concat my SQL strings like this (easier
to read), so I do this until I'm ready to optimise my app.
Dim UpdateStament as String = "INSERT INTO network_servers
(network,server) VALUES ('<network>','<server>')"
UpdateStatement = replaceAll(UpdateStatement,"<network>",network)
UpdateStatement = replaceAll(UpdateStatement,"<sever>",server)
database.SQLexecute(UpdateStament)
- Tom
On 16/02/2007, at 5:39 PM, Jeffrey Ellis wrote:
I've got the creation of the database and table going. But
inserting the
data I'm still struggling with, as you can see.
I tried writing your line as:
database.SQLexecute("insert into network_servers ( network, server)
values
('" + network + "','" + server + "')")
But I get a type mismatch...
All My Best,
Jeffrey
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>
