DLL Functions

[kandan]

hi,

I've created a counter table (NextAvailID), and when someone wants to insert a record into the "main" table, I want to read the counter table (NextAvailID), increment the value by 1 and then update the counter table (NextAvailID). This will give me the next available primary ID to insert into my "main" table.

The problem is, I need SPECIFICS (like actual ADO commands) on how to read and update this "counter" table so no other user can even read this "counter" table until it is updated with the incremented value.

can any1 help me out!!!!!!!!!! its urgent...
kandan
E-mail: rg_kandan@usa.net
ICQ: 52774533

[msdnexpert]

Try the following be opening a recordset on the table.

MyRecordset.open "NextAvailID",connection object,adoopenkeyset,adlockpessimistic,adcmdtable

[Jefe]

Hello, I have a question about DLLs. Is there a way to get the parameter info on functions that are included inside a DLL? I have this 'Dependency Walker' that was included with Visual Studio 6 Pro, but it only shows the DLL's functions, but not their parameters. Does anyone have any ideas?

[Crazy D]

There's only one way, and that is, documentation provided by the supplier of the dll. If it's M$ dll's, big chance you'll find something in MSDN. If it's from some one else, you're stuck to their documentation. Sometimes there's a header file (.h) included for usuage from C/C++, but if you don't have any documentation, there's no way you can find out the parameters.

[disruptivehair]

The United Kingdom consists of:
England, Wales, Scotland and Northern Ireland

Great Britain consists of:
England, Wales and Scotland

Therefore England is only one part of Great Britain/The United Kingdom

Don't let the Channel Islands people know you've left them out...oooh, they're a stroppy lot. :D