Search results for query: *

I have now defined a char array for each input parameter string and then populated the argv array with the pointers to these and that has worked. int argc = 5; char p0[50] = "\0"; char p1[50] = "str1=data"; char p2[50] = "ps=Y"; char p3[50] = "file=hj.srt"; char p4[50] = "\0"; char* argv[] =...

I am writing some unit tests and would like to be able to assign values to argc & argv in the code, rather than pass them through the command line. I have tried int argc = 4; char* argv[] = {"prog_main", "str1=data", "ps=Y", "file=hj.srt"}; prog_main(argc, argv); However within prog_main...

I've found that this was actually a problem with the data, I stupidly assumed it would be in the format I had specified. So in fact it does load data with leading zeros into numeric fields sucessfully. Sorry, Laura

I am happy to lose the leading zeros when it is stored in my table. As a work around I'll have to add a expression into the load and take off the DIRECT_LOAD option, but I was hoping that there was a better way. Thanks for replying Laura

I have a field that contains leading zeros that I would like to load into a numeric field. When I try and load it I get the following error: Record 15846: Rejected - Error on table <table_name>, column <column_name>. ORA-01722: invalid number How can I get SQL Loader to accept that this is a...

Not sure if this is possible. We have received a file that seems to have lost it's end-of-line markers. So that the data looks like this (sort of!): 02iunujgybbgY 02itgujgybbiY 02iuerjgrtrgY I did a dir/full name.dat and it said that the Record format: Fixed length 512...

When I try to open the table it says &quot;File 'p:\clients\active\c\cranfield.dbc' does not exist.&quot; FYI my table I am trying to open is in 'p:\clients\active\c\cranfield\p031008\conduit data\' and 'p:\clients\active\c\cranfield\' is a folder. Let me know if you need anything else...

Dear All, We only work with standalone FoxPro tables, so only deal with *.dbf, *.cdx and *.idx. I have a table which I created, but for some reason it won't let me open this without a *.dbc file, which doesn't and has never existed. Does anyone know how I can get round this? This is the...

Yes I am sure! I am copying text from a FoxPro table into an Excel spreadhseet. Once they are both open it works fine. I can't link this to installing any new software and don't know anyone else in the company who suffers from this. Any ideas?

Hi there, I used to be able to copy something from an application, open a new one and then paste it. However, now I have to have both applications open before I start. Does anyone know what is going on or how I can correct this? Thanks in advance, Laura

Thanks Rob, I didn't think of doing it twice - I knew I must be missing something! I can sleep easy at night now. Laura

I have read several threads explaining how to format columns when using Text to Columns in Excel. I however have a variation on this problem.... I need to force the first row of my csv file to be Text in Excel. So that when I have ranges such as 05-10 it doesn't reformat this as a date. But...

I am sure that there will be a very easy answer to this question but .... How do I fix my Command Window and Data Session when I open FoxPro? My colleague has re-installed his FoxPro and his boxes now open where he left them last time. I know that I could re-install my version, but I would...

Firstly I have very little knowledge of Oracle so if any of you answer me can you do it simply! Thanks.... So, I had to modify an Oracle Table [valcompany] to increase the size of a column. This was OK and the structure was changed to this: COLUMN NAME TYPE LENGTH NULLABLE...

I need to truncate a double data type and then only work with the &quot;Whole&quot; number part. ie when the number in question is 18.336 I only need 18.