Author |
Message |
Topic: a seemingly trivial read statement question |
dmcmillan
Replies: 7
Views: 9045
|
Forum: Support Posted: Mon Jun 15, 2009 3:19 pm Subject: |
Thank you again John. Will be sure to give you a mention if any of the outputs reach the public domain.
David |
Topic: a seemingly trivial read statement question |
dmcmillan
Replies: 7
Views: 9045
|
Forum: Support Posted: Mon Jun 15, 2009 1:44 pm Subject: |
hi could i ask, are the (char) functions you are referring to intrinsic?
i cant seem to find an intrinsic funtion for what i want to do (i.e. read whole line as a string and count the number of se ... |
Topic: a seemingly trivial read statement question |
dmcmillan
Replies: 7
Views: 9045
|
Forum: Support Posted: Mon Jun 15, 2009 12:04 pm Subject: |
Hello John,
Thanks so much for the prompt reply.
OK so it looks like i need to read up on my string operations! I was just wondering if it was possible to avoid this by using a read that would s ... |
Topic: a seemingly trivial read statement question |
dmcmillan
Replies: 7
Views: 9045
|
Forum: Support Posted: Mon Jun 15, 2009 11:22 am Subject: a seemingly trivial read statement question |
Hello,
is there a way of executing a read statement so that you stay on the same line of the input file as opposed to moving to the next line down?
This seems trivial but I can't seem to find a ... |
Topic: f90sql and excel |
dmcmillan
Replies: 3
Views: 8293
|
Forum: General Posted: Mon Jun 15, 2009 11:11 am Subject: belated reply |
Hello to those who replied. Sorry its taken me so long to come back to this.
As sparge said its not as simple as my 2 lines of code suggests. You do indeed need to call full_sql_error in order to d ... |
Topic: f90sql and excel |
dmcmillan
Replies: 3
Views: 8293
|
Forum: General Posted: Tue Dec 09, 2008 2:55 pm Subject: f90sql and excel |
Hello,
After successfully using f90sql to interface with .mdb files a while back, I thought it would be pretty straightforward to do the same with excel (reading values from certain columns of exce ... |
Topic: Use of SUM intrinsic array operator |
dmcmillan
Replies: 2
Views: 6552
|
Forum: General Posted: Wed Jun 18, 2008 12:21 pm Subject: |
Perfect - thanks for that.
DM |
Topic: Use of SUM intrinsic array operator |
dmcmillan
Replies: 2
Views: 6552
|
Forum: General Posted: Wed Jun 18, 2008 11:38 am Subject: Use of SUM intrinsic array operator |
Hello,
I want to sum the columns of a 20 x 20 array. So far I have used:
SUM (myarray,DIM=1)
which gives back an 20 element array with the sum of each row. I want to select the rows individua ... |
Topic: STRING TO DOUBLE CONVERSION |
dmcmillan
Replies: 2
Views: 8283
|
Forum: General Posted: Wed Feb 28, 2007 4:57 pm Subject: Oh dear |
Thanks
David |
Topic: STRING TO DOUBLE CONVERSION |
dmcmillan
Replies: 2
Views: 8283
|
Forum: General Posted: Tue Feb 13, 2007 2:42 pm Subject: STRING TO DOUBLE CONVERSION |
Hello,
Seems like a simple problem, however the 'dbl' and 'real' conversion functions don't work with character type.
Does anyone know of a solution for this?
Many Thanks
D McMillan |
Topic: Reading values from MS Access Database |
dmcmillan
Replies: 12
Views: 22399
|
Forum: General Posted: Wed Dec 13, 2006 2:49 pm Subject: Small steps... |
It turns out that the above error is caused because of an empty field in the data ... can anyone tell me how to deal with empty fields using the fetch command in f90SQL (without crashing the program!) ... |
Topic: Reading values from MS Access Database |
dmcmillan
Replies: 12
Views: 22399
|
Forum: General Posted: Fri Dec 08, 2006 12:39 pm Subject: And for my next problem .... |
Hello again,
I seem to have corrected the problems above, and now have a new one.
I have a seemingly random error with the fetch routine (using f90SQL): I am reading 2 columns (2 and 33) scannin ... |
Topic: Reading values from MS Access Database |
dmcmillan
Replies: 12
Views: 22399
|
Forum: General Posted: Thu Dec 07, 2006 3:24 pm Subject: f90SQL-lite |
I have been using the f90SQL-lite software to interafce with the access database, however I have a problem:
1. The maximmum number of rows I can access is 128, a limitation built into the lite ver ... |
Topic: 'use' |
dmcmillan
Replies: 2
Views: 8282
|
Forum: General Posted: Wed Dec 06, 2006 11:20 am Subject: working it out |
Many Thanks for that.
David |
Topic: 'use' |
dmcmillan
Replies: 2
Views: 8282
|
Forum: General Posted: Tue Dec 05, 2006 12:56 pm Subject: 'use' |
Hello,
I am tying to run some example code to get my program interfacing with an access database. The problem I have is with the 'use' command:
use f90SQL
The code then calls one of the funct ... |
|