How can user defined fields be updated via the maximizer odbc driver.

I tried the following:

update U_SkillA set U_SkillA='newval' where clientid='01222236655C'

insert into U_SkillA (clientid,U_SkillA) values('01222236655C','newval')

Can someone help me?

The following worked for me:

INSERT INTO U_SKILLA ( Client_Id, Contact_Number, U_SkillA )
SELECT '040704000011010294922C' AS Expr1, 0 AS Expr2, 'newval' AS Expr3

Thanks

I will try it

Tobie

Hey Tobie, how are you accessing the maximizer data via the Maximizer ODBC driver?

Like via VB, C#, C+ ?


I have no problem accessing it with Pervasive's ODBC Engine Interface but I cant figure out a the connection string to connect using Maximziers ODBC driver which I need (Rather than the pervasive one).

If you have a snippet or something, would you mind posting it here?

>I cant figure out a the connection string to connect using
>Maximziers ODBC driver

Create a System DSN and use that.