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!

Register Log in
  • Congratulations Rhinorhino 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: MrDontKnowNothing
  • Order by date
  1. MrDontKnowNothing

    more than distinct

    hi folks, when using a distinct on a table, i only get the data one time. that's fine but in the following example it's a little inappropriate... having a table like this: id | email ---------------- 1 | a@b.com 2 | b@b.com 2 | c@b.com 3 | d@b.com 4 | e@b.com 4 |...
  2. MrDontKnowNothing

    obtain dublicates from a table

    hi again, a question of interrest and frequent use: asume you got a table called costumer with columns id, name, email. you know there are some costumers in the db with the same name and email, but different id: ---id---|---name---|---email--- 1 john j@b.com 2 john...
  3. MrDontKnowNothing

    field length when importing from excel

    hi folks, does anybody know, where vfp obtains the field lengths of a table when importing from excel? mfg alex
  4. MrDontKnowNothing

    programm does not terminate properly

    hi folks, i wrote a little *.prg wich executes a form. everything works properly except i compile it to an *.exe. after i press the "quit" button, the application disapears from the taskbar, but does remain in the taskmanager. any explanation? thanks! alex
  5. MrDontKnowNothing

    new to php : pass query string to same form

    i tried your solutions before, but i do have an array in the query string and therefore aidz98'code doesn't work properly. when using something like dkduge's code, a recursively growing querystring will result. so i'll try to ask a better way: what kind of mechanismns does php provide...
  6. MrDontKnowNothing

    new to php : pass query string to same form

    hi folks, i'm quite new to php, so don't wonder... i do have a form with already got some data in the query string. but when i try <form action&quot;<?php echo &quot;thisdocument.php?&quot;.$GLOBALS['QUERY_STRING'];?> name=&quot;myform&quot; method=&quot;get&quot;> ... i only receive the...
  7. MrDontKnowNothing

    can't see form

    found in the form designer, but still the same result. i see the vfp enviroment popping up for a second and it's gone... cheers alex
  8. MrDontKnowNothing

    can't see form

    no idea...where can i do that?
  9. MrDontKnowNothing

    can't see form

    hi folks, i wrote a *.prg wich calls a form like &quot;do form myform with parm&quot;. within foxpro i can execute the *.prog and the form pops up and everthing is fine, but if i compile the *.prog and build an *.exe it doesn't work at all. (i see the form flimmering for a second). any ideas...
  10. MrDontKnowNothing

    want to open an excel file within a *.prg

    groovy! thanks! alex
  11. MrDontKnowNothing

    want to open an excel file within a *.prg

    i agree, but what if somebody installed excel in a different path? therefore i'd prefer a more generic method. thanks alex
  12. MrDontKnowNothing

    want to open an excel file within a *.prg

    hi folks, what kind of command should i use, if i plan to open an excel-file from a *.prg so that excel pops up? thanks! alex
  13. MrDontKnowNothing

    release a table

    hi folks, i beg your pardon for this stupid question but i would like to close a table explicitly, but &quot;mytable.close&quot; does not work and &quot;close tables&quot; as well. muchas gracias alex
  14. MrDontKnowNothing

    Copy To xxx.xls XL5 truncating to 16384 rows

    hi mike, i was more intrested in where this value -4143 is comming from... btw, i do have good hand for things, which work generally, but not with me. therefore, i should become a tester. ;-) thanks anyway, i gonna check this on monday. have a nice and relaxed weekend! alex
  15. MrDontKnowNothing

    Copy To xxx.xls XL5 truncating to 16384 rows

    morning folks ;-), mike: the &quot;xlWorkbookNormal&quot; was defined in your .prg, wasn't it? anyway, i tried it with hardcoding and got the same result. sorry for my ignorance, but what is this #define standing for? btw: i use various versions of excel, but non older than the officeXP...
  16. MrDontKnowNothing

    Copy To xxx.xls XL5 truncating to 16384 rows

    sorry mike, but i've tried your &quot;Copy2Xls.prg&quot; in order to solve the 16384 problem. 1. thanks for offering a workaround 2. unfortunatelly, i can't use this due to an error at this line => loXls.ActiveSheet.saveAs(tcExcelFile, xlWorkbookNormal) errocode: 0x800a03ec and something...
  17. MrDontKnowNothing

    missing data after export...

    hi folks, i run a script with a sql-query. when i browse the result, i can see 18000 records. after i use &quot;Exort to file.xls XLS&quot; there are only 16384 left. any explanation for this strange behaviour? thanks! alex
  18. MrDontKnowNothing

    regular expressions

    hi little helpers, is there a way to use regular expressions in vfp7? muchas gracias alex
  19. MrDontKnowNothing

    access columns via index

    sorry, this was corresponding to the suggestion with AFIELDS(). probably gonna start my weekend and check out things on monday ;-) cheers alex
  20. MrDontKnowNothing

    access columns via index

    well, the afields() would be approbriate, but i don't think it would be a good idea to put a lot of data into a array... (eats up memory, doesn't it?) ramanis version is, what i actually wanted, but is there a way to do it inline? i have tried: scan if &field(1) = &quot;&quot; then...

Part and Inventory Search

Back
Top