Insert a new record

[AGMV]

How I can insert a new record in a MAS90 file from a VB Application?.
I am using the Providex ODBC.

It is possible to use a SQL Sentece like "INSERT INTO"?

 

[BeejCyr]

THats the theory I am working under. The ODBC driver installed with the MAS90 client is a read only one. Providex makes a version 3.22 (

http://www.pvx.com)

that is supposed to allow writes when you install it with the custom settings. However, while I no longer get an error, my data still does not seem to end up in the table. So I am still chugging away at that.

 

[cleith]

I have use Insert Into with 3.22 and the record was there when I queried in VB and displayed in a grid. Blew up MAS90 though as I didn't populate all the necessary fields, but the 'insert into' did work.

The 3.22 I downloaded appeared to be only demo without purchase. I am using 3.00 with came with MAS90 3.21.

I have problem Selecting Table/Columns with '/' in the field name.

Cheers

 

[BeejCyr]

Well I had the same problem, but I have nother program I wrote to give me the file layouts from the SOTAMAS90 DSN. While it does contain the slashes, my data browser does not. SO I tried dropping the slash and it worked fine.

Now I am trying to instert a record with a date in it. I keep getting an error no matter what format I try.

This is the statement:

Insert into IMG_TransDataEntryHeader (TransactionDate, TransactionType, RefNumber, Comment, ToWhseCode, LinkToFirstDetailRecord, DefaultFromWhseCode) VALUES ( '10/31/2002' , '1' , '00000023', 'Brian Test' , '' , 4 , '396')

I have tried the date with and without single qutoes & double quotes, using dashes instead of slashes, backslashes, curly brackets, anything I can think of. I have tried it in yyyymmdd format

ANy ideas?

 

[cleith]

Insert Into BM1_BillMaterialsHeader(LastUsed) Values {d '2002-10-18'} )

Were you able to d/l ODBC 3.4 without demo restrictions?

 

[BeejCyr]

I downloaded 3.22. During the install it askes for a serial number, I just followed the information in the instal instructions on how to derive the serial number and it works.

THanks for the sample code. It worked great.