This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
31
Programming / grid help fill up
« on: January 11, 2021, 07:37:50 PM »
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 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
32
Nomads / Toolbar on panel
« on: December 21, 2020, 02:29:42 PM »
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
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
33
ODBC / invalid Operand for operator <Assigment>
« on: November 29, 2020, 08:13:50 PM »
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.
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.
34
ODBC / Re: Can't install podb400 driver
« on: March 10, 2020, 05:26:17 PM »
Ok thanks let me contact them.
35
ODBC / Re: Can't install podb400 driver
« on: March 05, 2020, 01:19:45 PM »
I don't think so is from sage because the error come from odbc driver here a display erro you can see.
36
ODBC / Re: Can't install podb400 driver
« on: March 03, 2020, 01:35:42 PM »
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
could not start transaction odbc error : SQLError Record 1:sqlstate:s1c00
37
ODBC / Re: Can't install podb400 driver
« on: March 02, 2020, 09:06:18 AM »
Thanks let me try driver to see if that works.
38
Programming / odbc send me this error
« on: March 02, 2020, 09:01:30 AM »
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.
could not start transaction odbc error : SQLError Record 1:sqlstate:s1c00
if i connect not problem
how i can see tables
thanks.
39
ODBC / Can't install podb400 driver
« on: February 28, 2020, 09:18:18 AM »
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
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