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 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
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...
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...
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?
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...
I know this doesn't help exactly...however, I would have said that this is standard Windows behaviour. For all you know, a user of the site may wish to scroll through the drop down options with their mouse.
To illustrate my problem, with the code above, use the following for the 'something' line:
<nobr>Something ... Something ... Something ... Something ... Something ... Something ... Something ... Something ... </nobr>
Make a small window so that it doesn't all fit in, and then refresh. You...
I have the style below to create a narrow 'bar' across the top of my page. This works fine, however, when I have a window that scrolls to the right, the 'bar' does not draw in the scrolled area. i.e. there is white space from the edge of the original window area to the far right of the page...
Thanks very much. This has worked fine. Any idea if LIMIT is supported in Oracle 10g? Seems a long way round what must be a common problem.
Once again, help very much appreciated.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.