Search results for query: *

Hi guys, I'm busily porting some SVS Pascal to run under GPC and the compiler has got very upset at (nearly) this line... myArray : ARRAY [1..myConst,1:50] OF myType; Any ideas what that colon does in the second dimension of the array declaration? This was written in Corel some 20 years ago...

Hi, I have a pretty sizeable table, nothing massive but big enough to warrant an index being created on what would be the "foreign key". The thing is that each day my program runs and it rebuilds the index and then drops it when it is completed, a process which takes about a minute, and I was...

Hi guys, I've searched through this forum for answers but whilst people have often been in the same situation as me nobody has ever given an answer, so I'm asking it again. I've downloaded and installed the server, client and shared-compat rpm's. I run bin/mysql_install_db with no problems...

Quick one. Is their a Java library/API for System V IPC suite? Jo

Right, this one is getting on my nerves! How do I get the system data and time? Can't find it!! Jo

I have a development PC that cannot be put on the net for security reasons and it would help me greatly if I could download a copy of the J2SE API spec you can access at java.sun.com. I can't seem to find it though. Anyone know if it's possible to download it, and if it is can you point me in...

Hi there, Basically I'm trying to put together an idea of what i need for my first wifi network. I've seen a linksys BEFW11S4 for really cheap and I think I only need 802.11b as 11Mbps seems fast enough for me. Is there anything else I should consider that would mean I should opt for the more...

Is there a way of exporting a spreadsheet to a comma-delimited file so that all fields will be padded out to a fixed length size? ie "hello,,there,everyone" might be (if all set to eight chars)... "hello , ,there ,everyone" Cheers! Jo

Hi there, I have two tables, one representing stations, one representing platforms. Platform records are linked to stations by a foriegn key STATION_KEY in the table platforms. Some stations have multiple platforms, some have none at all and here lies my problem. I want to be able to display...

Hi all, I have a perfectly normal table of the following pattern: key (int), values....... the key is tied into the values though. The problem is I've got to a stage where the keys are out of order so ever query has to have an "order by" clause in it. To save me effort (:P) is...

Hi all, I make a mysql query using mysql_query(..). I then use mysql_store_result(..) to get a MYSQL_RES *result_set. I then run mysql_fetch_row(..) repeatedly over the set to do something or other. My question is is it possible to reset to the beginning of the MYSQL_RES *result_set so that...

Hello all, I have a table with four simple columns. One column (UID) of this table contains a "unique" field, but there can be multiple entires of this "unique" field. The reason being that if an update record has been entered this field will be in two places and I am in...

Hello all, I've got a query I need to run and i don't know if I can do it one pure MySQL query without reverting to C code and slow lookups (these tables are BIG!). The scenario is I have one main table with records in and another with date ranges for the records in the first table, obviously...

Hello! I wonder if anyone can tell me why when I enter data into a table using the autoincrement facility, the key is going up by four each time! Strange! Jo

Hi all, Got myself a bit stuck using MySQL through the C API. My code goes : res = mysql_store_result(&mysql); row = mysql_fetch_row(res); now I want it to say something like mystruct.intvalue = (int)row[0] mystruct.charvalue = (char)row[1] etc but this creates all sorts of errors Any...

Hello everyone, Simple question (I think) that I can't find a definitive answer for. Basically I'm trying to compare some max and min values against explicit values, ie. SELET ....., max(working_time), min(working_time) FROM tableA WHERE .... AND MAX(working_time) < &quot;1200&quot; GROUP BY...

Hi guys, I've come across a problem which I believe is to do with the auto increment feature and wondered if anyone else had come across it. Basically to keep it simple I've got one table with an integer key set to auto increment. I need to have this enabled to allow new records to be added...

Hello all, I have a set of tables that work on a very basic tree-like structure with one &quot;master&quot; table at the root. I have to copy data from these tables into other tables of exactly the same format if a condition is met for the master record. My question is : when I copy the...

I'm having a bit of bother. I have two tables, one is called da7hdr and contains the main details for what I'm doing. I then have a table called da7hdrd which relates to da7hdr by each of its records having a value called hdr_key which references the da7hdr.hdr_key (so it's a foreign key if...