Show Posts
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