Here my progress and frustation with query and globals,  statusbars  is a start of new road with not idea what can find in there and lack not guide tutorial, but any way i can sad i tried and how long i don't know but hope go far of this...

Hope some body help this   

Hi i will tried is from query when user click on OK button assign values from columns to global vars i don't if doing right or not i attached image what i doing hopping get some help..
 
on program show me error too for access variables to sorry but i learning and is not easy when you don't have samples...

Whay show like that i need to create a format for that column secound column

Hi well could be i almnost quite eagain of this game, I know could my questions are so stuppied or not interest any body last nigth i tried to active a panel or query from meny and send me error on path if you can see emage  there all object on libreary my questions why send me this error..

Hello there is way to declare a global varibale for example if i select a company to that value for change of directory for tables, i look and read manuel i don't see something like that...

Thanks
Any help are welcome...

Hi i tried to start a query but i don't know exactly what i miss when run  test send me a error
you see i have table but why don't show up records..

Hello there small book tutorial to start stady pxplus and learn how to programin

Thanks
any help great..

Hi i have files created with old pvx software date create is 2004 but i can not access with pvx server some like pvx basic or some something like that 

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...