PxPlus User Forum

Twitter Twitter Twitter

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.


Messages - eldonfsr

Pages: [1] 2 3
1
ODBC / wHAT odbc USE PVX
« on: March 03, 2024, 07:49:27 PM »
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...
   

2
Programming / Can create a Browse Query
« on: March 03, 2024, 01:20:21 PM »
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..

 

3
Nomads / Re: Tool to update providex.ddf file to new version
« on: March 02, 2024, 03:53:16 PM »
Wow great but can affect that datas on tables if app is access with old format or old definition....could affect? 

4
ODBC / What is the _S on table definition fields
« on: March 02, 2024, 03:16:09 PM »
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....

5
ODBC / Re: UPdtae table send me message column not found
« on: February 29, 2024, 11:41:26 AM »
Thanks so much for your replay  i appreciate this.
 
there a way from command line run utility to fix that problem... because i don't have nomads  for 32 bits...the version i have is 64 bits and don't know could affect all information on table.

6
ODBC / Re: UPdtae table send me message column not found
« on: February 28, 2024, 09:26:13 AM »
The dictionary is of mas90 countrycode is string 3  and look only accept 2...

7
ODBC / Re: UPdtae table send me message column not found
« on: February 28, 2024, 09:22:05 AM »
Thanks for you time and help me here image of my test and file definition... some look is take country as length of 2 but is 3 characters string..

8
ODBC / Re: UPdtae table send me message column not found
« on: February 27, 2024, 04:41:59 PM »
Yes looks is working but if you check the information on table is not show up as must be some information from column is put into other column spread the information
UPDATE  AR1_CustomerMaster  SET  CustomerName=''California Metal Services Inc'' ,AddressLine1=''1428 W Mission Road'',AddressLine2=''1430 '',AddressLine3='' '',City=''CARLSBAD'' ,State=''CA'' ,CountryCode=''USA'', ZipCode=''92008''  where   Division=''00'' and CustomerNumber=''CMS''

you see countrycode is now as in sql ... some put in conactcode and other countrycode

some strange on sqlodbc...
 



9
ODBC / UPdtae table send me message column not found
« on: February 26, 2024, 03:52:35 PM »
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"

10
ODBC / Serius I complete missing undesrtand odbc
« on: February 17, 2024, 07:35:15 PM »
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...
     

11
Nomads / Tool to update providex.ddf file to new version
« on: February 13, 2024, 07:08:25 PM »
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...

12
ODBC / Re: odbc let connect but not accept user login
« on: February 12, 2024, 11:53:21 AM »
This the first error show up

13
ODBC / Re: odbc let connect but not accept user login
« on: February 12, 2024, 11:46:52 AM »
Thanks works..

Sorry if ask some more about this, It let me connect to data base i created a Combobox to get the catalog from database but when i run query sad error no data dictionary fond, but is strange show me all tables names..

you can see on attaches..

14
ODBC / odbc let connect but not accept user login
« on: February 10, 2024, 12:04:38 PM »
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....

15
ODBC / Dates Columns how convert to string
« on: February 07, 2024, 10:51:11 AM »
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...

Pages: [1] 2 3