Search results for query: *

Thanks for your swift response 'rosenk', I have tried your suggestion, but unfortunately nothing has changed the error message is the same, thanks anyways, anymore suggestions? :) Regards Mark.

Hi, below is my function, for some reason when trying to use the function, it says there is a 'Parse error at or new "1$", does anyone know why it is saying this because it looks ok to me ? Please see below: CREATE FUNCTION newcalls(varchar, varchar, varchar, varchar, varchar...

Im a total C++ Builder n00b, I just want to place the results of a db query into a variable ! How do I do this ? e.g. String a, loc, type; loc = "Alice"; type = "Select id from location where ward = '"; type += loc; type += "'"; //Edit1->Text = type...

Thanks to the people that have allready given me advice, it has been help but I am still very stuck, I cant seem to find examples thats show me howto translate my Procedures into functions. I have serveral SQL Server Stored Procedures to translate into PostgreSQL functions (the returned values...

I have serveral SQL Server Stored Procedures to translate into PostgreSQL functions. I would be very grateful if some wonderfull person could give me idea of how to do this, below is a very simplest example of one of my Stored Procedures, could someone show me how this would written in PL/pgSQL...

Hi all, I need translate some SQL server Stored Procedures into PostgreSQL Functions, how can I do this ? Any help with this will be appretiated greatly. Regards, Mark.