PureBasic Forums - English

Hi
I have taken my purebasic to my laptop when I am away to an office of a friend. I wrote a program on the desktop with .pb and .pbf files and a data file. When I take it to the laptop and try to save the source code changes it won't save the changes. This must have to do with sharing or ...

Wow!

An embarrassment of answers. Thanks so much. This is a great birthday present!

Hi,

I'm wondering if someone can point me to a solution for opening sqlite databases.

I want an routine that will open the database "example.s3db" say in the default file area. If it can't be found there then the program offers the request/browse screen and/or an option to create a new empty ...

Hi

I realize that srod is producing the grid for purebasic these days and there is another fellow who made some modifications to one of your native tools that does a few things with a grid. However, these people are mere mortals and if they pass away or become uninterested this is not how a decent ...

Ok. I used your code and it does work as you said. Sorry for the misunderstanding. I think I will just use a calendar gadget to change the date if need be and a string gadget to get the final date which I can make the same background colors as the others.

Thanks for your help Rashad!

John

Hi
Are you sure you are duplicating the problem? enter a 1 in the first text box and then go back to the dategadget and try to change the date. It won't do it.

Thanks Rashad.

I had looked at the help doc but it says dategadget can be set with setcolor on the setcolor doc but on its own documentation it says that only calendar can be set with set color. So I missed that. But that still doesn't answer the fact that the date cannot be changed after I make a ...

Hi,

I am having some trouble changing the color for a dategadget . The doc says it can be done. Another problem is that when I move a date to the dategadget it then becomes unmodifiable if i just try to modify the text in the box. If I go into the calendar with a down arrow, it will allow me to ...

Yeah that could work if there arn't too many gaps. If there are then you would keep subtracting until you found something.

Hi
That is what I did. But I was hoping i could use the reverse index to do an efficient lookup in reverse

Here is what I do now :
SQL$ = "SELECT * FROM JobData WHERE JobID < '" + LASTKEY$ + "' order by JobID DESC LIMIT 1 ;"
This seems pretty inefficient to go through all the data just to get to ...

Hi

I have tried to create a reverse key for my main key in a simple database so that I can read the key in reverse order (to do a read previous on the table).

I use a query like select * from xyz table indexed by revindex. Revindex contains the key from the xyz table but in descending order.

The ...

Thanks people.

I think we have pretty well discussed this area. I am now curious about how to read previous in sqlite. I know you can't do it with PreviousDatbaseRow. I will create a new topic for discussing this area if I can't really get a solution today.

Hi

Here is the result of looking at debug SQL$ INSERT INTO JobData VALUES ('9422','ABC','12/02/2014','00:30','10','120','1200','8','45','0','0','0','0')
it sends text but it apparently converts correctly into a JobID because the record is added. I validate each fields before posting to make sure ...

Hi

I have settled on a final handling of this database insert issue. I have made the date and time fields in the data base into text fields. I have made the insert logic like this:

SQL$=""

SQL$ = "INSERT INTO JobData VALUES ('" +
SQL$ + GetGadgetText(#String_JobID) + "','" +
SQL ...

Yes that sqliteexpert.com site is fabulous. The freeware version is much better than sqliteadmin.

Nice suggestion.

John