Recent content by jdmartin74

Yeh. Found solution! Edit value 'CollatingSequence' in: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Paradox from 'Ascii' to 'International'. I also did the same in: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\3.5\Engines\Paradox

I've tried that, and I get an error saying "Incorrect collating sequence".

I have some data in what I believe is a Borland database using the BDE (Borland Database Engine). I have data files ending .DB, .PX, .XG0, XG1, etc. plus a few others I would like to get this data in Access. Does anyone know of any (ideally free) ODBC driver to do this or any other way? Thanks

Thanks. I had thought of that but thought there must be another way! I used MySQL a lot and you can do it with that!

I know it doesn't affect the working of the database, but for ease of understanding the set up later, I would like to alter an existing table and add a column to it before other columns. Does anyone know how to do it?

I'm not in a loop, but the lines: sql_stm := 'SELECT '||v_field||' from COMPANIES'; execute immediate sql_stm into v_address; are exactly what I needed. Thanks so much.

I have a function which is passed a value. I wish to make up a field name based on that value: v_field := 'ADDRESS_' || p_line; The above line would give v_field a value of 'ADDRESS_1' for example. I then want to do: SELECT v_field INTO v_address from COMPANIES; This works in so far as the...

I have tried this. Access seems to overide based on regional settings still. The format applies but the comma is treated as a thousand seperator and the period as a decimal. Access is obviously reading the local regional settings to get this information.

I have a report displaying numbers for different countries. I can identify each country but wish to display the numbers differently for each. For example, 10,453.56 for a UK number and 10.453,56 for a French/German etc. number. Access is always using my default locale but I need this to change...

Thanks. I'll give it a go.

I have a database with a table of images stored as OLE Object field types. I would like to export these to individual files, however, I can't seem to do it. I have tried the following code below. It works in that the file is written, however, it is not a usable bitmap file. Can anyone help...

This may also help... http://www.puschitz.com/InstallingOracle9i.html

Getting PHP to work with Oracle can be a right pain. I spent a long time trying to get this to work and did finally crack it. What OS are you using for your PHP?

Thanks very much. I knew there was an easy way. I just couldn't find it for looking!

I need to pass an ampersand character on an address line as part of a value. I realise obviously that the ampersand character breaks each field on the address line when used with the GET variable; which is exactly my problem. Does anyone know how a field value on a GET line can contain an...