Search results for query: *

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 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 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...

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 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...

I am writing a web page that returns back a long list of results based on an Oracle DB. Because I am getting many hundred results back, I would like to limit these on a per page basis and only show 100 records per page and have a 'Next Page' and 'Previous Page' option at the bottom as is very...

I wonder if anyone has crossed this and has an answer... I have a query which is doing to_number(field) on one of the columns. My problem is this data (users being users) has some mis-typed values. e.g. '1.r' instead of '1.4'. Obviously, when the query runs, it gets an invalid number. Is there...

I'm hoping this is an easy question, but I'm not sure what I'm trying is possible or not. No matter how much reading I do, I can't find the answer. I have a table, as follows: <table class='report'> <tr> <th>Column heading 1</th> <th>Column heading 1</th> <th>Column heading 1</th> </tr> <tr>...

Does anyone know of a way to open a new window to be identical in terms of toolbar, size, etc. to the original? I would like to put a link on a page to offer the user to open a new window, the behaviour of which is identical to pressing Ctrl+N. I know I could use window.opener.location but I...

I have just installed Oracle on a LINUX box. The database is on a Windows 2000 server. I would like a PHP script to connect to this. I've created a script based on the manual which I understand should work. I get an error however. I just wondered if anyone with any experiencing of using the...

I have been trying to achieve the above today and after reviewing many articles and posts in this forum (and a bit of head scratching) I have finally got it working. I thought rather than reply to a few posts, I would post a new thread with my results. The following link...

I have a view which when ran as raw SQL (i.e. just the SELECT statement) is quicker than when I do a SELECT * FROM {view} Does anyone have any tips to speed up the performance of Oracle views? Thanks J.

Does anyone know of a way to 'remove' the scroll bars on a window? I can change the colour, but can't find a way of removing them. The Microsoft Windows update page manages this. Thanks

Hi, I've done some PHP4 programming, but I am fairly new to classes. I have got something working to handle a session, populating a MySQL database. This all works fine. My next task is to use this in conjunction with forcing users to log on to an Intranet system. I need to be able to put...

I have an Oracle database running on a Windows 2000 server. I also have a Linux (Red Hat 7.2) server running Apache and PHP. I would like to access the Oracle database in my PHP pages. I've started down the route of installing Oracle on the Linux box but seem to be working blind and coming upon...