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 - Per E. Johannessen

Pages: 1 [2] 3 4 ... 12
16
Programming / Re: ODBC VX-Rexx/DBExpert
« on: November 16, 2020, 04:23:35 pm »
Found the SQL statement in a file named window1.vry and it is identical to the one produced by DBExpert.

Does anyone happen to have Watcom SQL?
Believe that one is doing well with VX-Rexx so I'd like to try it if it was available anywhere.

17
Programming / Re: ODBC VX-Rexx/DBExpert
« on: November 15, 2020, 12:19:26 am »
Yes, can do without 'INNER JOIN' in this case, but this was just an example to trigger the error.
Most queries in this project are quite simple, however I a need a few that involves up to four tables and several joins.

Have tried to find the actual syntax/code VX-Rexx creates by searching the various sections involved but no luck so far.

18
Programming / Re: ODBC VX-Rexx/DBExpert
« on: November 14, 2020, 05:55:55 pm »
Here is an example of an error I get when running the SQL statement with VX-Rexx.
(The same SQL statement produces the expected result and no errors with DBExpert.)



19
Programming / Re: ODBC VX-Rexx/DBExpert
« on: November 13, 2020, 06:38:12 pm »
I don't have ODBCADM.EXE in os2\apps\bin, however the one I use is \dbexpert\odbcadm.exe and it works ok.
Think the problem is with the odbc.dll so it would be nice to find out what SQL commands it supports, and/or find out what's blocking
VX-Rexx from using all the functions.

You mentioned that your odbcadm.exe does nothing. Doesn't it even bring up the dialog window where you can define databases etc.?

20
Programming / Re: ODBC VX-Rexx/DBExpert
« on: November 13, 2020, 03:47:04 pm »
Had a look at RexxSQL but it seems that it needs an ODBC driver for connecting to the dBase files and I only have the drivers and manager
that were supplied with DBExpert. Suspect that these drivers are somehow modified to fully work with DBE only.

Does anyone know where I can obtain fully working ODBC drivers ?

21
Programming / ODBC VX-Rexx/DBExpert
« on: November 12, 2020, 01:32:42 pm »
Does anyone have experience using the dBase IV/ODBC driver that is bundled with DBExpert under VX-Rexx?
Simple queries work fine from VX-Rexx, but when I try SQL commands like 'INNER JOIN' and 'AS' I get various errors.
Even if I create the SQL in DBExpert, where it runs perfectly, using exactly the same sql-query in VX-Rexx results in errors.

22
Programming / VX-Rexx container - get values
« on: October 08, 2020, 07:39:37 pm »
Hi,

I have a VX-Rexx project with a container filled with values from a query named "QRY_AVR".
The container has 4 columns and 4 records:

----------------------
|AAAA|BBBB|CCCC|DDDD |
----------------------
|   1|2004|  10|35490|
|   1|2004|  12|  732|
|   1|2004|  50|-8150|
|   1|2004|  99|-7320|
----------------------


The code below returns the sum of column "DDDD" (20752):

sum = 0

ok = VRMethod( "QRY_AVR", "MoveFirst" )
do while( ok = 1 )
    call VRMethod "QRY_AVR", "RowData", "data."
    str = ""
    sum = sum + data.4
    do i = 1 to data.0
    str = str data.i
    end
        ok = VRMethod( "QRY_AVR", "MoveNext" ) 
end

However, sometimes I need to get a specific value from the container.
Let's say I need the value in "DDDD" which corresponds to to the value "12" in "CCCC",
anyone knows how to do that?

(I can get the needed values using several queries, but prefer some rexx-code to do the job.)

23
Mail-News / Re: Mail disappeared SeaMonkey
« on: August 19, 2020, 09:04:59 pm »
Have to investigate about SMART, but chkdsk, with or without /f, does not report any issues.
(The SSD drive was new in january this year.)

24
Mail-News / Re: Mail disappeared SeaMonkey
« on: August 19, 2020, 07:30:41 pm »
I've already used DFSee but only to check for errors and it did not find any.
Looks like I have to read the manual before using any of DFSee's recovery tools......

25
Mail-News / Re: Mail disappeared SeaMonkey
« on: August 19, 2020, 06:54:31 pm »
Yes I have checked the profiles folder and now I noticed that more folders/files are missing:
in \profiles\fakename.xyz\ there is only one folder named MAIL which contains 3 subfolders, one for each mail account, and each of them only contains the files I mentioned before, (the empty files created today; Inbox, Inbox.msf, Trash and Trash.mfs).

Just discovered another thing; tried to start OpenOffice Calc and it now starts with presenting the "Welcome to OpenOffice" like it does after a fresh installation. The OO package is installed on the same partition as the SeaMonkey mail stuff. I was using OO Calc a lot yesterday and at one point I had to restart it due to some calculation functions stopped working and after restarting it all worked again. As far as I can see all OO directories/files are where they should be. Other programs on this partition work fine.

26
Mail-News / Mail disappeared SeaMonkey
« on: August 19, 2020, 05:00:12 pm »
When booting AOS today I got the message "The program pointed to by the SET RUNWORKPLACE= line in config.sys could not be started".
I then replaced os2.ini and os2sys.ini with recent backed up versions and the system boots fine and all seems intact except e-mail folders which I have on a JFS partition.

Started SeaMonkey mail and it showed only 3 of 7 mail accounts, but there are no mails in any of them, also the subfolders are not displayed. In each accounts folder there are only four files; Inbox, Inbox.msf, Trash, and Trash.mfs, and they all seem to have been recreated today by SeaMonkey.
All other folders and files on this JFS partition are OK.

Before restoring mail from a back up I'd like to try to recover the files. (The back up is unfortunately a couple of weeks old.)

So far I've only tried JUne and it does not find the missing files. JRescuer seems to be for JFS volumes which are "unavailable" so I have not tried it.

Ideas anyone?

27
Networking / Re: VNC/FTP Asus RT-AC1750U
« on: February 16, 2020, 01:07:03 pm »
Turned out to be simpler than I feared, both vnc and ftp works after filling in correct values in the settings for "port forwarding".

28
Networking / Re: VNC/FTP Asus RT-AC1750U
« on: February 15, 2020, 10:28:43 pm »
Thanks for info, don't have the manual here, but found this https://www.asus.com/support/FAQ/114093/ so I'll give it a try.

Good to know about the "OS/2 Voice option", I'll go that route if I can't get it to work.


29
Networking / VNC/FTP Asus RT-AC1750U
« on: February 15, 2020, 05:24:08 pm »
Need to set up a new Asus RT-AC1750U for accepting incoming VNC and FTP connections. This router has lots of options and I have no experience with this stuff. The router is at a remote site and I can connect and configure it remotely. Basically I need to connect to a pc running VNC server at the remote site, and probably a ftp-server. (The pc I want to connect to is running eCS.)
Appreciate if someone can help with this.

30
Setup & Installation / Re: Airboot & GPT
« on: January 25, 2020, 11:58:07 pm »
I'm going to have a "shared" partiiton on the Win10 disk and I would not be able to access it from ArcaOS if it was not converted to MBR.

Pages: 1 [2] 3 4 ... 12