Hi sorry for this topic could be not what not right what i see and what i tested, with nomads i can connect to database open tables show information suppose  when you create a query you sad is database or odbc , as you can see on attach image, but when you use odbc outside of pvx going completed wrong you can connect and open tables and see the information why is the big quetion...
   

Hello is possible to cerate browse query to show customer information and add buttons to add, delete, edit , I made a test and create a browse query but just to show information and the options , select , search, sort but i don't  see option to add buttons..

Hi on mas I see several Fields _S1.._S7 and _N1...N5 open what is the mean of that..
please explain me lite about that....

Hello well juts testing to run sql look message i follow documentation and examples to write sql statement correct
just on first column the values must be on single '' or bouble  "" , if i put on single '' don't  send error but all information is mixed on fields , so put "" and send this error...what i doing wrong..

SQL Error: [ProvideX][ODBC Driver]Column not found: California Metal Services Inc 
Code: -2147467259 SQL:  UPDATE  AR1_CustomerMaster  SET  CustomerName="California Metal Services Inc " ,
AddressLine1= "1428 W Mission Road ",
AddressLine2= "1430 ",
AddressLine3= " ",
City= "ESCONDIDO " ,
State= "CA " ,
CountryCode= "SA "
where   Division="00"
and CustomerNumber="CMS"

ODBC let i setting and test and sad connection successful but just i close odbc32 and open again and to configuration of dns now sad connections failed, so  tried  differents options and i dont get  this works..... even i change setting of odbc on mas90 to let access tables and fields, i created a special user to give access all tables and fields, is strange because is not when run some sql is just login so i thinking is not on setting of odbc on mas90.... you can see on attach first to is when i setting odbc and last 2 image is after re open odbc, not change nothing just ask connect again..

why is so difficult to work with this odbc..... I read a lot of links a documentations and nothing....

Different odbc version...
     

Hello is there a tool to update providex.ddf to new version of pvx, or how to generate a new ddf with infomation of old file..


thanks...

Hello odbc pvx is connect to database but not let me login the user sad user invalid user / password
but show me the users to select user.....

what can be fact don't let me login....

you can see on attachs....

Hello friend just question how i can datecolumn from  sql to put in sql not as date as string
i dis some but separete like this
       DataModule1.ZQPo.SQL.Text:='select PO1_PurchaseOrderEntryHeader.* , {fm MONTH(PurchaseOrderDate)}  as  NewDate  from PO1_PurchaseOrderEntryHeader  ';
this generate a new comlun names newdate but i need hold column not juts month or day or year sepate
is sow some with scalar....

  {fd DATETOSTR(PurchaseOrderDate)}  as  NewDate

could be possible...

I tried to config odbc driver 7.1 to connect local machine but always send error on catalog on documentation sad only remote access server

Name of catalog. A catalog defines a remote data dictionary and/or INI file and optionally a prefix. A maximum number of 256 catalogs may be defined

on screen you don't see any example of catalog how to config odbc....


thanks any help be great...

Hi sorry for the question i created some dictionary and see what files create and witch doesn't create too, to config odbc ask need catalog documentation just sad ini file but on folder we created ddf not cerate any ini file where is create that or where is catalog when created dictionary i don't see any field witch reference to catalog, please somebody cam  explain me that please....

Well i install and confing odbc but i don't get connected , you can see the screen and information i put in there but i don't know why allways sad error connection.....

What i doing wrong i don't know somebody can help me please...

Hi i need some body explain a lite bit about join left and right i trying to execute select query i read manuals and supost syntax is like that..

select * from { OJ IM1_inventoryMasterFile  full outer join AP1_VendorMaster  left outer join IMA_ProductLine   on IMA_ProductLine.ProductLineCode=IM1_inventoryMasterFile.productLine on AP1_VendorMaster.VendorNumber=IM1_inventoryMasterFile.PrimaryVendorNumber  } where IM1_inventoryMasterFile.itemnumber=:pprod 

what i need is get inventorymaterfile get all information and link Ima_productLineCode to get description of product line and from ap1_vendorMaster get vendor name , but send me error productline column not found.. this column is on inventorymasterfile..... what is rigth syntax to get access the imnformation...

Hi i made configuration of DSN file and debug tested connection and sad connection success, but when try to use the driver form lazarus send a message driver not capable.... what is mean of that?

Also i install server and odbc 5.2  and run it, but how i can use client or odbc for example localhost because if i connect computer to different network the ip change so i have to setup the ip con client side......

Sorry for topic but documentation is very short and don't explain many things...
   

Is possible to align grid to client or like docking left, right i don't some option for that.. 

Hello sorry for topic i tried differents options on  pvx nomads  but i don't get to do some form like show on attach...

Well yesterday i was testing PVX nomads trying to create a panels and menu to call that panel but if you see and Task Definition some wrong
Mnu_options on combo box show complete different option
if i need to active a panel what i need to select.... if you follow instructions show there show error syntax error, no logic label...

How i can define logic for menu item , I create main panel and add a Menu but i don't find where put that...
in Function what is the option to select ( call, ignore, performance, execute...) when i select call show message sad no logic label supplied i hope some body can help me with that .......

thanks

I have this SQL statements but when is executed send a error not found indentifier

select PurchaseOrderNumber, PurchaseOrderDate, Vendorname, ItemNumber  from  {  oj   #PO1_PurchaseOrderEntryHeader  INNER  JOIN #PO2_PurchaseOrderEntryLine ON #PO1_PurchaseOrderEntryHeader.PurchaseOrderNumber = #PO2_PurchaseOrderEntryLine.PurchaseOrderNumber }  WHERE  PO1_PurchaseOrderEntryHeader.PurchaseOrderDate =  {d"2015-08-05"}

what i doing wrong...

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