Xequte User Forums - Seeking experiences with ODBC Connector

Xequte User Forums

Profile Active Topics Forum FAQ

Forum membership is Free! Click Join to sign-up
Username:	Password:
Save Password
Forgot your Password?

Forum Tips
» This forum is for users to discuss their software problems and suggestions for improvement. Remember that only a tiny percentage of our users experience such problems (To be precise less than 0.7% have ever posted on this forum)
» Include your software version number (as displayed in the About Box)
» Check the FAQ before posting as most common questions have already been answered
» You don't need to also e-mail us separately as our support team will respond to all questions on this forum

All Forums

Xequte User Forums

MailList King

Seeking experiences with ODBC Connector

New Topic

Reply to Topic

Printer Friendly

Author

Topic

Andrew Dearing

France
15 Posts

Posted - Jan 19 2009 : 01:25:49

I hae no problems using the ODBC connector to read the MLK database - it works fine with Excel and using the Perl/DBI module. Updating the database is more problematic - I assume that the Index fields in each table are autoincremented, but it's not obvious how to obtain the field value of the new records.

Has anyone managed to get the ODBC connector working for database updates?

xequte

7504 Posts

Posted - Jan 19 2009 : 14:20:24

Hi Andrew

Yes, all of the Index fields are auto increment fields so you don't need to specify them directly. Just pass null for the field value.

Nigel
Xequte Software
www.xequte.com
nigel@xequte.com

bell1jl

USA
12 Posts

Posted - Mar 05 2009 : 10:21:05

Have you been able to figure out how to update the MLK DB through ODBC? I'm trying to use Access and can read it fine but I am unable to edit.

Topic

New Topic

Reply to Topic

Printer Friendly