UDF ODBC How can Update

tobieheynsNew Member

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?

8/5/0412:07 PM

❤️ 0

Original Post

Replies sorted oldest to newest

gordNew Member

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

8/5/043:06 PM

❤️ 0

tobieheynsNew Member

Thanks

I will try it

Tobie

8/5/043:14 PM

❤️ 0

benfNew Member

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?

9/1/046:52 PM

❤️ 0

gordNew Member

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

Create a System DSN and use that.

9/2/042:52 PM

❤️ 0

Skip to main content

Add Reply

Membership Required

Remove From Your Block List

Manage Follow Preferences

Block

Please wait...