PureBasic Forums - English

Thank-you for all these suggestions. You have given me something to think about before I attempt to re-write the application in Purebasic.

Simon

add a rPi ( Zero or W ) at each location and allow that to collect the data from the equipment and then let that call home to your collection program on a scheduled basis.

You would have to write a script to poll the quipment on the rPi, but you wouldn't be limited to a line at a time form ...

Do you have the ability to install your own program on a computer on the same remote network where the equipment is located?

If so, then install your polling program locally on the remote network. In that window of time when you don't worry about interruptions do the equipment polling and save ...

In the WriteProgramString() documentation it states:

The program to use. It must have been started before with RunProgram() and the #PB_Program_Write flag.

Now lets assume I have a program called RunProgramMgr() that uses RunProgram(MyProgram). Is there a way to have MyProgram write data back ...

Hi

The data is transferred as a line of ascii text that must be acknowledged before the next line is sent. This just happens to be the way the equipment operates and I have no control over that. The equipment is spread out all over the country often in remote locations and some with poor internet ...

In the WriteProgramString() documentation it states:

The program to use. It must have been started before with RunProgram() and the #PB_Program_Write flag.

Now lets assume I have a program called RunProgramMgr() that uses RunProgram(MyProgram). Is there a way to have MyProgram write data back to ...

Hi

I am just looking for ideas on how to best handle the following scenario in Linux. I have 200 remote locations and growing where I need to get data. It can take a few seconds to 10 minutes per location to get the data because the equipment sends the data one line of text at a time. All data must ...

Procedure.i dBRecord(Map tmRec.dBValue(),tnDb.i=#dCDatabaseNo)
Define ln.i
ClearMap(tmRec())

For ln=0 To DatabaseColumns(tnDb)-1
Select DatabaseColumnType(tnDb,ln)
Case #PB_Database_String
If CheckDatabaseNull(tnDb,ln)
tmRec(DatabaseColumnName(tnDb,ln))\ValueS = ""
Else
tmRec ...

Hi

When I use the CheckDatabaseNull() function I always see the following message in the console window:

row number -1 is out of range 0..-1

I am using Postgres as the database. Is this an error message of some kind or can it be safely ignored? The function is working correctly so I am ...

Hi

It is definitely not dead and very useful. If you want web based applications you can choose SpiderBasic or you can use PB with https://webui.me which is what I have done with some projects.

Simon

I have been testing out the serial port feature in PB today, and i'm not having the greatest success.

This program: Port$ = "COM4"
If OpenSerialPort(1, Port$, 9600, #PB_SerialPort_NoParity, 8, 1, #PB_SerialPort_RtsCtsHandshake, 128, 128)
For x=1 To 10
WriteSerialPortString(1,"IS THIS WORKING ...

Hi

I generally check the DatabaseQuery and report any errors. So I will check my code because I may have missed a spot and that may explain why my code is not handling the disconnect properly.

Thanks JHPJHP for all your input.

Simon

Hi

I tried the code but it does not do what I need. I stepped through the code and just before executing the IF PQStatus() I restarted the Postgres server and it still reported the connection was successful.

Simon


Hi swhite,

I completely misread your first post, thanks spikey for the clarity ...

Hi

I will look into PQStatus as I know that anything using a select statement will fail because that is the problem I am experiencing when the server is reset.

Thanks,
Simon

Hi

I had a situation where a Postgres Server was restarted and my application crashed even though I used the IsDatabase() function to check that #Database was valid. IsDatabase() continue to return a value despite the fact that the connection had been reset. Is there a way to detect when the ...