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
on 2/13/07 11:16 PM, Norman Palardy <[EMAIL PROTECTED]>
wrote:
> You just did all the "hard work" describing what you need to do
> No real need to put both the network and server into one field since
> in SQL you can search on multiple fields very easily
>
> The only thing your missing is
>
> 1) create a file to hold the database
> 2) create a table - create table network_servers ( network text,
> server text)
> 3) insert each row as you figure out what should be in it -
> "insert into network_servers ( network, server) values ('" + network
> + "','" + server + "')"
> 4) check for errors along the way
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>
