PureBasic Forums - English

This is great, but is there a way to step through an xml document looking just for <section> tags (or others) and get the attributes from them?

I am trying to use an xhtml document as a template and imbed the sql queries to fill out the data.

Thanks

I need some help with the XML. I am trying to extract text from an XML document I load into a string.

<section id="sm51_title_bar_sql" class="sql"> /* SM51 Title Bar Query */
SELECT title AS sm51_title_bar,
description AS sm51_desc,
status AS sm51_status
FROM rep.sm51_title_bar;
</section ...

Thanks Fred! You're the best!

Yes, you have been lucky. It took us a while to find it, but when we create a view with an ORDER BY statement:

SELECT DISTINCT jobid,
datetime(start_tmx,'unixepoch') start,
datetime(end_tmx,'unixepoch') end,
(strftime('%s','now','localtime') - start_tmx) / 3600 age,
CASE WHEN end_tmx > 0 THEN
end ...

Can you share how you did it or the library? We are having an issue with earlier versions (like 3.7.9) of SQLite (the current compile version for v5.0 of PB). We need 3.7.13 or better.

Any help is appreciated. This is a commercial project we are working on.

Thanks

2012-06-11 (3.7.13) is working. But 3.7.9 or earlier does not.

Thanks

Hello PB Group,

I discovered that the libraries that PB uses for SQLite have an error in them with ORDER BY statements. This is true of any program using the older libraries (discovered it in the SQLite Manger plug-in for FireFox). I don't know how to update the libraries, is there a way to do that ...

OK. It is working now. I guess the compile with the ProcedureDLL statements did not compile or my AV program grabbed it. Thanks for the help. It looks like we should be using Prototypes instead so I will need to look at that further.

It has been a long time since I've worked with DLLs in PB. I created one using ProcedureDLL and compiled it, but when I connect and try to read the procedures, they don't seem to be recognized. What am I doing wrong?

Here is the code to read the library file. Do I need to DeclareDLL all the ...

What I am asking is, I need to run an outside program and feed it parameters. Then catch the output (stdout). Can that be done with threads so that the "RunProgram" calls happen asynchronously?

I have not used threading but I have a project that requires some calls (run program) to a Java program that returns information in the stdout. This is a communication call, my program takes the stdout and parses the information to a database. I know I can't get a return from a Thread, but is there ...

It works (I don't know why) but I had to change it a bit cause I was getting an array out of bounds error.

Procedure.l zExecuteSQLQuery(SQL.s,Array dat.DatabaseRow(1))
Protected.l hndDB = zOpenSQLDatabase("","")
Protected.l ttlcol,col,count = 0

If IsDatabase(hndDB)
If DatabaseQuery(hndDB ...

I will give it a try, but can you explain how it works?

DB

Hello,

I am trying to create a procedure that will fill an array with data rows from a SQL query. I am having trouble passing the array. I want to dimension it and then redim to the size of the number of rows. Something like this:

Procedure.l zExecuteSQLQuery(SQL.s,Array dat(10))
Protected.l ...

I figured out what is going on. When I set the GadgetItemState() to select the previously selected tree item (the last time the program was run) and then use GetGadgetText() is selects the first item on the list.

I used this code to select the item.

SetActiveGadget(Main_treeClients ...