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

 

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"

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

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

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

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