PureBasic Forums - English

Can PB direct Postgres to run stored procedures?

I wonder if there is any kind of release timetable? It would be nice to know when to expect the next version even in approximate terms.

Using SQL-Server as a back end probably comes at a cost. Two things that I can think of are having to use surrogate keys on all tables, which can kill performance in some cases, and that some of the data bound controls do not work, when ms-access is set to use ansi compatible SQL/SQL Server SQL ...

Just a guess, PB would not have a concept of data-bound forms would it? Code would need to be written for feeding data into each control and then back into a database if a user changed a record? Bound forms are a lot less work but unbound forms have more possibility.

@ the.weavster.
Almost every professional developer says that ms-access is flaky. However when you have been using it for 20 years, one develops an instinct for tiptoeing around the land mines.
I did take a look as Lazarus, it on this machine but the IDE is ugly compared (crikey - the screen font ...

Thanks everyone,

I am not doubting anyone and have had similar experiences. I have never gotten on well with Visual Studio so have not gone in that direction - PB was like fresh air in comparison. So how could the PB users deepen the pool of knowledge re making great database applications?

Does ...

I have gone back to ms-access for application development. Interesting ideas picked up in this forum have helped me create a coding style in ms-access that helped me overcome many of the limitations that I was having.

Ms-access can do OOP but if there is a bug, it is very bad at breaking on the ...

Thanks Bluenzl, I am reading the survival guide.

@ jagermeister
I think that what is needed is for a lot of people to pool their resource and make it easier to learn how to make database applications. As much as I like this forum, wonder if it is the right way to create a knowledge base. Recently I have been using StackExchange (in relation to ...

Thanks acreis,
I will give it a go. The StrPtr function is not listed in the ms-access developer reference so no one would find it from that starting point.

On another matter there is another problem with using dll's in ms-access and that is that the path to the dll is hardwritten into the declare ...

Thanks netmaestro,
As I have to pass the variable as reference, I should be able to continue using the same variable after pb has altered it. I think the issue is that I don't know how to read the memory address provided my ms-access in pb.

I have to meditate on the code above for a while.

Cheers

I would like to get string operations working, namely to pass a string from ms-access to pb, change the string in pb and then get the changed string back in ms-access. Here is some test code that I am working to identify the issue. I have not worked with pointers before so the problem lies here.

PB ...

On close investigation, the issue is not a PureBasic bug, rather it is bad information in the PB help file. According to a MicroSofts MSDN web site at DLL can only return a number as a function return which explains why I can get the DLL to work with numbers. In the case of strings, the DLL can ...

I note that there is a 3D programming section on the PureBasic Forum. Would it be a good idea to have database programming section too. I am a heavy ms-access user and an occasional Postgres experimenter. The thing that holds me back in developing applications in purebasic that run off postgres is ...

If I create a DLL that returns a string to ms-access, ms-access 'stops working' and crashes. If I convert the string to a double, then the DLL works fine an ms-access does not crash. I also suspect that the DLL remains loaded after the calling script has terminated however this could be by design ...