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: *

  1. NasibKalsi

    How To Replace Data To Another Table With Conditions

    try this select tblItems * ------------ set date ansi set century on copy to temp * If you want to view just 1 item then * copy to temp for item = "ballpen" t_date = set("DATE") use temp in 0 alias temp select temp index on ITEM + DTOC(date) + STATUS to temp total on ITEM+DTOC(DATE) + STATUS...
  2. NasibKalsi

    updating table with a .cdx

    This may be helpful set talk off set echo off clear close all delete file t-name.* create table t-name free (FIELD1 c(10), RESULT c(20)) insert into t-name (FIELD1) values ("1.2.3") insert into t-name (FIELD1) values ("1.1") insert into t-name (FIELD1) values ("1") insert into t-name...
  3. NasibKalsi

    updating table with a .cdx

    you can try index on str(len(alltrim(PARENTEELID))) + PARENTEELID tag HIERARCHY I tried to test your code and found that I can not call 'user defined functions' with Field Name(s) for creating indexes. This will not work: Hierarchy(PARENTEELID) or Hierarchy(FIELDNAME). There is an error...
  4. NasibKalsi

    Converting a string to a numeric value when exporting from a dbf to excel

    * Add 2 numeric fields to the TemapCursor i.e. NEWPRIX and NEWTOTP select 00000000.00 as NEWPRIX, 00000000.00 as NEWTOTP, ; line, order.itemno, percentage, invoice, cusno, table1.descrip as Description,; table1.sccal as Scientific_cal, str(int(Percentage/100*table1->pack),4) as pack...
  5. NasibKalsi

    simple loop ( my memory is not good)

    * Simplify the above same code so you may be able to see the syntax error lcCrlf = CHR(13) + CHR(10) lcLine = "" FOR lnI = 1 to 24 lcI = TRANSFORM(lnI) lcLine = "CENTRY" + lcI lcLine = EVAL(lcLine) lcLine = lcLine + " " lcLine = lcLine + lcCrLf STRTOFILE(lcLine, "garble.log",1)...
  6. NasibKalsi

    Fatal Error: C0000094 on Windows 10 PC

    Very basic info: May be stop outlook for few days for debugging purposes. 'End Task' for any outlook instance(s) I guess rest of the application works fine except this option.
  7. NasibKalsi

    vfp9 get data from google maps

    If !Empty(lcAddress1) Or !Empty(lcAddress2) * I think, you mean If !( Empty(lcAddress1) Or Empty(lcAddress2) )
  8. NasibKalsi

    Need help displaying data on a Visual fox pro report

    if you have not solved your issue yet, then 1. show sample data 2. show how you need to separate 3. how you index it i mean index expression
  9. NasibKalsi

    Index on date range help - thanks

    Mike -> "I disagree with Nasib. Using THISFORM in an index is not a good idea" But same is true for filter. In IkonTechDev' situation using 'index' or 'filter' will have the same scope limitations. There is extra cost on recreating his logic to accomodate the suggested changes. I guess...
  10. NasibKalsi

    Index on date range help - thanks

    This is simply to answer your question, such that you can do it. But follow what is said above. * Upper case is FIELDNAME * Limit dataset access based on DateRange index on trans(DATEFLD >= thisform.FromDate.value and DATEFLD <= thisform.ToDate.value) + alltrim(EMPID) tag MyOrder set key to...
  11. NasibKalsi

    RENAME changes upper to lower

    try command interpreter run rename lower.csv UPPER.CSV there is no 'to' reserve word in the command above.
  12. NasibKalsi

    how to hack details band's -&gt; &quot;start detail band on new page when less than&quot; at run tim

    If I understand correctly: You want to print multiple complete addresses on the same page if space available. That is if space available after printing x bands. Is the address band the last one on the report ? You could have a counter which will tell where you are on the report at any given...
  13. NasibKalsi

    how to hack details band's -&gt; &quot;start detail band on new page when less than&quot; at run tim

    Some more ideas: Assuming each line height is the same and you can print 50 lines per page. Add a field call it may be LINENO N 4 and another one call it may be NEWPAGE L Have the table ready to print with no active index. Update LINENO from 1 to 8, for each label, assuming you have maximum 8...
  14. NasibKalsi

    How to print Report

    Picking up ideas from above, You could try a label and duplicate your records to print 2 copies to a same page. Create a cursor with duplicate record such that duplicates appear together. Then create a Label report and feed the newly created cursor to it. If you have to print a separating...
  15. NasibKalsi

    Form and Class

    Thank you Vilhelm-Ion, Olaf and Mike for taking the time to reply. I was expecting in DE when Clicking on Form Form New Property && Exists New Method && Exists New Class && Does not Exist I was thinking there may be a way to have 'New Class' as well. I am a bit lazy and...
  16. NasibKalsi

    Form and Class

    Hi all: is there exist a user defined class local to the form ? As we have user defined methods local to the form. my best nasib
  17. NasibKalsi

    Report printing records multiple times

    is there any possibility to call a function instead of iif(.....) ?
  18. NasibKalsi

    Instead of in Leading zeros show * instead of 0 in Reports and forms , Grids

    You may try the following Modify your cursor to include 2 Char type fields for example CNUMBER, CSTARS then replace all CNUMBER with alltrim(str(INUMBER)) replace all CSTARS with left("********************",15-len(alltrim(CNUMBER)) && Modify the len as required in your report print both...
  19. NasibKalsi

    Counting seconds from 1 to xxx until job finish

    may be t_MessageTime = 2 && how often to display (in seconds) t_PreSeconds = 0 scan * * code * if abs( seconds() - t_PreSeconds ) >= t_MessageTime wait window "Working - " + time() nowait noclear t_PreSeconds = seconds() endif endscan wait clear && Clear...
  20. NasibKalsi

    Problem on updating record balance

    i am not sure your question. If you are new to SQL,may be you could use the following approach * * ITEMNAME : name of the field where you stored 'LAPTOP', 'PRINTER', etc. use delivery in 0 alias tmpdelivery again sele tmpdelivery index on ITEMNAME to tmp total on ITEMNAME to tmp && sums all...

Part and Inventory Search

Back
Top