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.
16
ODBC / Re: catalog on odbc
« on: February 05, 2024, 08:23:45 PM »
Thanks so much let me tried to connect why they don't put that on documentation...
17
ODBC / catalog on odbc
« on: February 04, 2024, 11:54:23 AM »
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...
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...
18
ODBC / sorry for topic where is the catalog on odbc
« on: January 06, 2023, 12:26:14 PM »
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....
19
ODBC / pvx server obc install error connection
« on: January 03, 2023, 01:24:11 PM »
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...
What i doing wrong i don't know somebody can help me please...
20
ODBC / Re: ODBC 4.21 send me error not capable
« on: January 03, 2023, 10:30:47 AM »
With lazarus is possible to access database information of PVX, In my case to connect to MAS90 i download and install lazarus 1.2.0 and connect to mas90, for now is great step now i working on config PVX server and ODBC to write on tables, if somebody got that please post your experience, i would like to work on pvx suite but not there to much manuals guide to read and follow step by step...
if somebody interested and test app i can send you by email...
Thanks.....
if somebody interested and test app i can send you by email...
Thanks.....
21
ODBC / join left and right join tables
« on: December 30, 2022, 07:11:38 PM »
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...
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...
22
ODBC / ODBC 4.21 send me error not capable
« on: December 24, 2022, 02:06:00 PM »
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...
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...
23
Nomads / grid align to client
« on: March 16, 2022, 11:51:56 AM »
Is possible to align grid to client or like docking left, right i don't some option for that..
24
Nomads / Re: Panel like This
« on: March 15, 2022, 08:14:55 PM »
Thanks Mike let me start to work on that.....I see some similar on demo custom but there use folder hope i can do some similar....
25
Nomads / Panel like This
« on: March 15, 2022, 02:29:22 PM »
Hello sorry for topic i tried differents options on pvx nomads but i don't get to do some form like show on attach...
27
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...
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...
28
Programming / How define logic for menu
« on: March 12, 2022, 10:10:11 PM »
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
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
29
ODBC / Re: Join Tables Error Identifier
« on: June 11, 2021, 12:46:14 PM »
select * from { oj PO1_PurchaseOrderEntryHeader INNER JOIN PO2_PurchaseOrderEntryLine ON PO1_PurchaseOrderEntryHeader.PurchaseOrderNumber = PO2_PurchaseOrderEntryLine.PurchaseOrderNumber } WHERE PO1_PurchaseOrderEntryHeader.PurchaseOrderDate = {d"2015-08-05"}
even i write without # is the same message...
even i write without # is the same message...
30
ODBC / Join Tables Error Identifier
« on: June 11, 2021, 11:17:48 AM »
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...
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...