Hello I started with PVX no many samples can find or see, is hard get a progress when you have some examples or tutorial

I working on small app i need to show and fill a grid with information , hope some body can help me just when select the form filter records and show in the grid.

screen attach image

00010 ! detalleforma.en --- Created on Thursday, December 31 2020 by enrique
00020 !
00030 !
00070 PROCESS_FORMANAME:
00071 READ (1,KEY=FORMNAME$,DOM=BADID)FORMNAME$,DESCRIPTION$
00072 LET REFRESH_FLG=1; RETURN
00090 BADID:
00100 MSGBOX "Form not registered"
00110 RETURN
00120 !
00130 PREDISPLAY_FORMDETALLE:
00140 OPEN (1,IOL=*)"Formasdatas"
00141 OPEN (2,IOL=*)"detformas"
00150 RETURN
00160 !
00170 CELL_CHANGE_GRID_DETAILFORMCFIELDNAMER0:
00171 READ (2,KEY=FORMNAME$:FIELDNAME$,DOM=BADIDF)FORMNAME$,FIELDNME$
00172 MSGBOX "FIELD DEFINED"
00180 RETURN
00190 BADIDF:
00200 RETURN
00210 !
00220 PROCESS_BUTTON_ADDROW:
00221 LET FIELDNAME$="DATE INVOICE"
00222 LET ID=1
00223 LET FIELDLINE=10
00224 LET FIELDLENGTH=11
00225 LET ISDETAIL$="N"
00226 WRITE (2)FORMNAME$,FIELDNAME$,FIELDLINE,FIELDLENGTH,ISDETAIL$
00230 RETURN


Thanks
Enrique Pineda

I don't have experience on PVX is my first time to work on it....
Hi i try tp find way to add toolbar buttons to panel but i don't find example and also on design tool i don't some reference to that soo come has a example or explain me how to do that please help me...



Thanks
Enrique

I have this sql statements to ejecute  but send that error

INSERT INTO PO5_ReceiptEntryHeader ( vendornumber , ReceiptNumber ,  batchnumber , ReceiptType ,InvoiceNumber,InvoiceDate,InvoiceDueDate,PurchaseOrderNumber,TaxableAmount)
VALUES(                               'CONT'     ,'064509'       , '00011'      ,'I'          ,' CAESC7796'  ,'10/29/2020','11/28/2020','T11499   ','     430.45')

i using c# i dont know if i have to use " or ' to in close value or is wrong date format .

please help me thanks.

Ok thanks let me contact them.

I don't think so is from sage because the error come from odbc driver here a display erro you can see.

I try to connect using odbc but send me this error when execute some query
could not start transaction odbc error :  SQLError  Record 1:sqlstate:s1c00

Thanks let me try driver to see if that works.

I try to connect using odbc but send me this error when execute some query
could not start transaction odbc error :  SQLError  Record 1:sqlstate:s1c00

if i connect not problem

how i can see tables

thanks.

When i try to install says this installation requires microsoft data access administrator

How i can install i know is old driver i running windows 10 64, my software is mas90 only i need is to connect and see structure of tables,
some body can help or guide to me please.

Fernando