I am trying to write a stored procedure to concatenate multiple rows of text together to return it as a single开发者_JAVA技巧 string. For example:
dear all.i\'m familiar with MySQL but not in Firebird. i try to search some particular data inside DB.But after i try to use \'%\' in where cluse i get some error message:
i try to put GROUP as concat in my PHP-Firebird. But it seems not work. my script like: $sGroupBy = \" GROUP BY LINE_NAME \";
i have some php script and i think this have a lot of mistake. because of my limited knowledge in concatenation and SQL injection. At 1st time i\'m not have any trouble because this script use PHP-Mys
I\'m having some problems in visualizing the data on a DBGrid. I\'m using Delphi 5.0 and I have a Interbase 6.0 DB with 50MB size
This is old stuff! Is related to delphi 5.0 and interbase 1.6. I\'m trying to open a DB connection via code. But this code is related to enabling the connection, all the components were added using d
I\'m using Firebird 2.1 and I\'m looking for the best way to solve this issue. I\'m writing a calendaring application. Different users\' calendar entries are stored in a big Calendar table. Each cale
I have Ms Access 2002 database that I need to convert to Fireb开发者_如何学Goird 2.5 embedded. What tool(s) that I can use to achieve this? Preferably freeware ones.
How can I search some particular character on the entire database with IBexpert? For example: I have some \"\'\" (\') in some part in the data of the tables and this is getting me an error later on,
It\'s possible insert a query in a count ODBC? Example: Select * From Customers where name = \'John\';