Stack Overflow
Stack Overflow

Questions tagged [frontbase]

FrontBase is a cross-platform SQL database with conformance to many international and de facto standards.

FrontBase is a cross-platform SQL database with conformance to many international and de facto standards.

FrontBase was created to fill the need for a robust and scalable relational database server that was Internet enabled, had no downtime, and required zero administration. FrontBase's speed, wide range of features, and flexible structure can give you the competitive edge.

Sources:

6 questions
2
votes
4 answers

OpenOffice SQL query date selection

I've been searching the web and asked around, but can't seem to find an answer to my problem... I have a running ODBC connection with my FrontBase database in OpenOffice Base. I manage to select everything I want, but when I only want to show the…
user3256812
2
votes
1 answer

Connecting PHP5 to a Frontbase Database

Is there a way to connect PHP5 to a Frontbase database? There seems to be an included connector, but it looks like that is not available anymore in PHP5: http://php.net/manual/en/book.fbsql.php
Alex
  • 32,506
  • 16
  • 106
  • 171
1
vote
1 answer

Convert an int column to a varchar in FrontBase SQL?

How do I convert an int column to a varchar in FrontBase SQL? I need to concatenate a varchar and an int field, and I cannot just concatenate them because both arguments need to be a varchar. I wanted to tag this "Frontbase" but I don't have…
Wouter Lievens
  • 4,019
  • 5
  • 41
  • 66
0
votes
1 answer

How do I left pad a database column in FrontBase?

I have a table of items (let's call it WIDGET) that each have their own eight-digit barcode numbers stored in a VARCHAR field (let's call it BARCODE; the table's primary key is in a separate integer column ID). My problem is that some rows include…
PleaseStand
  • 31,641
  • 6
  • 68
  • 95
0
votes
1 answer

how can I get the data out of an .fb file?

I'm working with a company trying to setup a new database system as their old database software has gone out of business. All the data is in a .fb file that is encrypted (You used to have to get backups 'unlocked' before they would let you use…
danjns
  • 1
0
votes
1 answer

Frontbase date formatting functions

I've searched all over and can't find any info in Frontbase documentation or, for that matter, SQL92-related docs...does Frontbase have functions equivalent to datepart/date_part, or date_format as found in other RDBMSes? I need to output a…
jscott
  • 1,011
  • 8
  • 21