Greetings, I excuse myself if this is not the right forum to ask this.

One of my client has seen the power of iNomads and they gave me a request, to make iNomads panels that open, read and update a database on their Microsoft SQL Server database.

I'm VERY newbie on this topic, barely have managed to run iNomands on a local network, so this client has a desktop software made on Visual Basic 6, but they loved how easily I managed to open pvx panels on Google Chrome via iNomads.

So, they installed their SQL Server database in my laptop, I was looking at the manual and ended up reading about the ADO command but I haven't been able to connect to the SQL Server database, everything I tried gives me an error 15.

For this test I'm only trying to OPEN and CLOSE it without actually reading anything, just trying to simply open it but it's not working:
The commented lines (starting with ! ) are all the examples I've tried and failed.

SADI\SQLEXPRESS is supposed to be the server name, dbo.D_Inventory is the Table I want to connect to (open then close)

LET CHAN=HFN
! OPEN (CHAN,OPT="CONNECT='Provider=SADI\SQLEXPRESS'")"[ADO]SADI\SQLEXPRESS;dbo.D_Inventory"
! OPEN (CHAN)"[ADO]SADI\SQLEXPRESS"
! OPEN (CHAN)"[ADO]SADI\SQLEXPRESS[dbo.D_INVENTORY][]"
! OPEN (CHAN)"[ADO]SADI\SQLEXPRESS.WMPOS[dbo.D_INVENTORY][]"
! OPEN (CHAN,IOL=*)"[ tag ] SADI\SQLEXPRESS.WMPOS ; dbo.D_INVENTORY [;fileopt ]"
CLOSE (CHAN)

I know nothing about this, I also read about ODBC but I haven't even been able to learn where to activate the ODBC license, let alone use that feature.

I got this far by reading the "Microsoft SQL Server Interface" part of the pvx manual.

For now it's just OPEN CLOSE, after is, OPEN, READ (a record), WRITE (to update it) then CLOSE.


Thanks for any help, I may be able to sell a few Web and Wayfarer Licenses if I can pull this off.

Greetings.

I'm trying to learn inomads since my clients are in need of it's benefits.
So far, I managed access the panels from Google Chrome on a phone, tablet and Handheld/PDA, worked wonderful.
However now I need to learn how to make it accessible from an external network.

For my local network test I used the following.
- Main program/panels etc, installed on a device at 10.0.0.71
- The EZ webserver runs in that machine using: *plus/spawn *ezweb/server -bkg -arg 8080
- On any mobile device connected to the same network I just open Chrome and type 10.0.0.71:8080 on URL and the app opens well.

However for accessing it from an external IP/Device not part of that local network, say personal phone.
I'm trying to do so using port forwarding on the modem that belongs to the local network.
- The modem locally has am IP 10.0.0.138
- Has a public IP of 72.50.4.97 or thats what google says.

Problem is when I type 72.50.4.97:8080 from an external device it doesn't land on the program, possibly because the power forwarding is not set correctly.

The modem in question has the following fields when setting up portforwarding:
- WanPort
- LanPort
- Internal Client (this is for the IP 10.0.0.71 where the program is)
- Protocol (Used both TCP/UDP)
- Enable Mapping (with a checkbox, not sure what this is)
- Wan Connection List (gives me a dropbox with 2 options, probably the names of the wireless signals)

I'm tried filling WanPort and LanPort with port 8080 or port 80, none have worked.

So then, I'm not sure where I'm missing what I'm missing, any hints?

The goal simply is to have access the panels via Chrome/Edge from an external network device.

Thanks a lot!

Hello team!

I'm having a little doubt in something I'm trying to do.

I have this small code:


02150 LIST_BOX LOAD ACCOUNTS.CTL,""
02190 LET CH1=HFN
02200 OPEN (CH1,IOL=*)"dta_ACCOUNTS"
02230 SELECT IOL=ACCOUNTS_IOL FROM (CH1),KNO=1
02261 LIST_BOX LOAD ACCOUNTS.CTL,0,STR(KEY)+SEP+ACCOUNTNUMBER$+SEP+ACCOUNTNAME$
02270 NEXT RECORD
02280 CLOSE (CH1)
02330 RETURN

I tried to run this code to load the listbox in order of account number hence the KNO=1, that worked well, BUT it's loading the listbox in alphanumeric manner since the account number is an string variable, like:

300
3100
315

Leaving the variable as string, is there a way to read the file as if it where numeric so that it sorts the data in numeric order when filling the listbox?

Like:
300
315
3100

Thanks a lot!

Hello

I'm working on a software for a client but I'm having an issue with a Listbox.

The program goes from:
-Log in Screen
- - Main Menu
- - - Chart of Accounts

When I enter the COA panel it loads everything well, the panel has only one listbox.

The problem is that when I pickup something from the listbox and close the panel, then reopen it, it gives me the following error:

"""""""""""
LOAD ERROR
Unable to set initial value for Listbox @(etc,etc)
Value that failed is etc,etc (whatever record I picked before closing)
"""""""""""
Then I just click "Ok" on the screen error and the panel keeps running normally, how can I skip that initial value?
Is there a command or something to release that value when closing the panel so that when I open the panel again it does not try to find what was selected before?

Thank you very much!