Questions tagged [openbase]

OpenBase SQL is a relational database server that provides data storage and multi-user access for networked users.

OpenBase SQL is a relational database server that provides data storage and multi-user access for networked users. It was originally developed for the OpenStep platform, and is now most heavily used on Mac OS X.

The system supports common access methods via JDBC and C, however it is optimized for use in conjunction with a variety of Macintosh-based development tools like WebObjects, RealBasic and Omnis Studio.

Product page.

5 questions
3
votes
4 answers

Openbase SQL case-sensitivity oddities ('=' vs. LIKE) - porting to MySQL

We are porting an app which formerly used Openbase 7 to now use MySQL 5.0. OB 7 did have quite badly defined (i.e. undocumented) behavior regarding case-sensitivity. We only found this out now when trying the same queries with MySQL. It appears that…
Thomas Tempelmann
  • 11,045
  • 8
  • 74
  • 149
0
votes
1 answer

IllegalArgumentException with Date value in jdbc; Openbase sql

I have a WebObjects app, Openbase db, and I'm getting a never before seen exception when doing a raw rows (non ORM) query during a batch operation. It looks like the jdbc adaptor is throwing on a date value in the db and is unable to coerce the raw…
wkhatch
  • 2,664
  • 7
  • 36
  • 45
0
votes
1 answer

PHP: Copy file from site A to site B

I have a server with 30 websites. Now I want to copy a file from site A to site B. Code: $sExternPath = str_replace(strtolower(SITENAME), strtolower($aBoardInfo['name']), CORE_PATH_PRIVATE); $sNewLogo =…
Pieter hein
  • 115
  • 1
  • 6
0
votes
2 answers

Left Outer Join query results in an error

This query throws ERROR - [position 0, near 'WHERE' in 'Select path.ePath, path._'] COMMA expected but not found in GROUP BY. This is my query: Select path.ePath, path._rowid, doc.Filenumber, COUNT(doc.ePathUID) AS children from docPath path LEFT…
Jim Geldermann
  • 183
  • 3
  • 18
0
votes
1 answer

How to use OpenBase SQL in Objective-c for iphone?

I trying to use OpenBase SQL in my code to save large amount of data. But I have one difficulty regarding this, I am not able to find the frameworks required for using OpenBase SQL in my code. I have found some coding part from the net but that is…
Atulkumar V. Jain
  • 5,102
  • 9
  • 44
  • 61