Menu

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.

Show posts Menu

Messages - eldonfsr

#16
Programming / Re: How start with PXPLUs
May 28, 2026, 10:00:56 AM
Thanks Len i working on just stuppid question where are locate examples on Pvx i reading pvx guide but i don't see any example on guide... how i con open a example
#17
Programming / How start with PXPLUs
May 26, 2026, 04:18:47 PM
Hello there small book tutorial to start stady pxplus and learn how to programin

Thanks
any help great..
#18
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 
#19
ODBC / wHAT odbc USE PVX
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...
   
#20
Programming / Can create a Browse Query
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..

#21
Wow great but can affect that datas on tables if app is access with old format or old definition....could affect? 
#22
ODBC / What is the _S on table definition fields
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....
#23
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.
#24
The dictionary is of mas90 countrycode is string 3  and look only accept 2...
#25
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..
#26
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...



#27
ODBC / UPdtae table send me message column not found
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"
#28
ODBC / Serius I complete missing undesrtand odbc
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...
     
#29
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...
#30
ODBC / Re: odbc let connect but not accept user login
February 12, 2024, 11:53:21 AM
This the first error show up