RE: xPLMediaNet - Need some .net oledb help please

["Tony Tofts" <tony@xxxxxxxxxx>]

Hi Keith,

> > I guess the only option is to amend the table and add an
autonumber
> > field, but this has implications for compatibility with
> mysql and mssql I think?
> >
>
> mySQL and MSSQL both have autonumber fields. You simply omit
> the key field from the insert statement as the database auto
> inserts it.

Thanks for the info.

Have opted for the md5hash at the moment, but it means a fair amount of
extra processing that could cause the watcher buffers to overflow.

Not too bothered about oracle, so if mysql/mssql support autonumber then
I'll change over to that.

Many thanks
Tony



xPL Links: http://www.xplproject.org.uk http://www.xplhal.com http://www.xpl.myby.co.uk
To Post a Message: ukha_xpl@xxxxxxx
To Subscribe:  ukha_xpl-subscribe@xxxxxxx
To Unsubscribe:  ukha_xpl-unsubscribe@xxxxxxx