Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: CJMK
  • Order by date
  1. CJMK

    import of .cls crashes vfp9

    Chris, Sorry, I am a bit slow with thanksgiving and all. I have tried importfromxlsx and it seems to bring the data over very nicely, but mostly in memo fields, so I am writing a little routine to map those over to appropriately typed regular fields. It requires positional consistency between...
  2. CJMK

    import of .cls crashes vfp9

    Mike, Thanks. Gets fatal error c0000005 message that refers to errorlog file that does not appear to exist where specified. (yes I have show hidden files on) screenshot attached. Click OK and immediate shutdown. If I just wait, freezes. file was downloaded as csv. So when that didn't work, I...
  3. CJMK

    import of .cls crashes vfp9

    import from .xls crashed vfp Tried appending from .csv, but yields extra rows by cutting off before end of record though why it should do this after a close paren is beyond me.
  4. CJMK

    Cannot get focus on listbox

    Mike, I think I found the answer. I tried an array with no success. The field I was using is integer. On a hunch I switched to character type and all returned to normal. Thanks for your attention - and it did push me in the right direction. Of course I am curious as to why they don't like...
  5. CJMK

    Cannot get focus on listbox

    Mike, Thanks for responding so quickly. Both the form and object are fresh out of the box. All settings are default except for control source and row source. adding a combo and screenshot to show, since I think the two issues must be connected somehow. The Combo does get focus, but does not...
  6. CJMK

    Cannot get focus on listbox

    Created simple listbox with rowsource and controlsource,one column. It populates from the table of 395 records, but cannot receive focus. Tabbing just skips it. Only three objects on form, others are command buttons included in the class. Combobox with same controlsource (record ID, a 5 digit...
  7. CJMK

    Color whole field in a report regardless of length of text in field

    Started this earlier but lost track of it. I did as you suggest already. Nice to know I was on track for once. I attach a screenshot of the result. And yes, am using multiple fields with appropriate print whens to control what shows for whom. The issue is that because of the proportional font...
  8. CJMK

    Color whole field in a report regardless of length of text in field

    Making badges for a conference (US Go Congress) I want the person's name on the top with a color background extending all the way across the badge. Ideally with the name centered, but that's hard in a proportional font (Using ariel) If the reporter sees spaces, it stops printing the color. I can...
  9. CJMK

    for endfor numeric increment turns to character after 9

    Hmmmm... I think Go players, particularly organizers, will claim they are at least competitive for title of "most argumentative and stubborn".
  10. CJMK

    for endfor numeric increment turns to character after 9

    All very interesting stuff. Will definitely alter my style.
  11. CJMK

    for endfor numeric increment turns to character after 9

    Thanks all - yes, I really wasn't thinking right for after 26. Getting soft in the head at my age (82) Will check out the resources. You are great.
  12. CJMK

    for endfor numeric increment turns to character after 9

    Feeling a bit sheepish. Should have found that myself. But I didn't think creating the field (with no actual record) would create the variable. Thanks a bunch.
  13. CJMK

    for endfor numeric increment turns to character after 9

    Here is the code PARAMETERS fn,numflds CREATE TABLE (fn) (A c(15)) i = 1 FOR i = 2 TO iif(numflds > 26,25,numflds) thisfld = CHR(i + 65) && B etc. ALTER table (fn) ADD column(thisfld) C(15) ENDFOR IF numflds > 26 FOR i = 27 TO numflds thisfld = CHR(65 + INT(i/65) + char(64 + i)...
  14. CJMK

    select {open filename] works fine native, but gives 107 operator operand mismatch in .exe

    Had similar issue on opening table, getting index error, and got around that by reindexing at first open. Now a very short time later, in init, I select it, and it gives me the 107. I am compiling with innosetup. It also is not finding another table and forcing me to locate it (right where it...
  15. CJMK

    index error occurs only in executable

    Program works fine in VFP9, but causes 114 error (Index does not match the table. Delete the index file and re-create the index.) when compiled into .exe by innosetup. If that had worked, of course I wouldn't be here. Deleted cdx and rebuilt. zapped table and appended from backup didn't work...
  16. CJMK

    sql statement throws 1707 (cdx not found) error but cdx is present and OK

    Olaf -- and all -- Thanks many times sorry if I missed a "great post" anywhere I solved the issue by keeping the exe, etc in x86 and putting the data in the root using commonappdata in INNO left me with the problem of setting the vfp path to find the data. I know there must be an answer, but...
  17. CJMK

    sql statement throws 1707 (cdx not found) error but cdx is present and OK

    That's what I thought. Never heard of a mythic vfp10. But by now, (in my book at least) it surely would make sense to allow it to go open source. Good to get the feedback on location. If nothing else works, I will go back to the root of c: No servers here. This will always be stand alone. And...
  18. CJMK

    sql statement throws 1707 (cdx not found) error but cdx is present and OK

    Olaf, Thanks. and sorry for delay in responding. Life interrupting. Yes, I did open and reindex the files prior to the problem point. forgot to mention that on my list. I have now tried using two letter aliases, to no effect. I have done only a few very simple setups, so not well versed there...
  19. CJMK

    sql statement throws 1707 (cdx not found) error but cdx is present and OK

    Note: very simple system to provide convenient management information from a single table obtained by combining data from three tables using sql. I have: Made sure the cdx is indeed present and functional Built project, exe, and used inno setup to compile install Works fine on my win 10 computer...
  20. CJMK

    Status bar blank

    Same here. If you are ever in the Seattle area, we have a spare bedroom available (most times).

Part and Inventory Search

Back
Top