variable Posts

{Too Long!}

Posted to MB Topic: Just Conversation « PrestwoodBoards Board

{Too Long!}

Posted to MB Topic: Just Conversation « PrestwoodBoards Board

{Too Long!}

Posted to MB Topic: H-1B Discussion « AmericanIT Board

{Too Long!}

Posted to MB Topic: Just Conversation « PrestwoodBoards Board

{Too Long!}

Posted to MB Topic: Computer Industry News & Trends « Industry Board

{Too Long!}

Posted to MB Topic: Just Conversation « PrestwoodBoards Board

{Too Long!}

Posted to MB Topic: Just Conversation « PrestwoodBoards Board

{Too Long!}

Posted to MB Topic: General Client Board « Client Board

{Too Long!}

Posted to MB Topic: Just Conversation « PrestwoodBoards Board

{Too Long!}

Posted to MB Topic: Just Conversation « PrestwoodBoards Board

{Too Long!}

Posted to MB Topic: Just Conversation « PrestwoodBoards Board

{Too Long!}

Posted to MB Topic: Just Conversation « PrestwoodBoards Board

{Too Long!}

Posted to MB Topic: Just Conversation « PrestwoodBoards Board

{Too Long!}

Posted to MB Topic: Offshoring Discussion « AmericanIT Board

{Too Long!}

Posted to MB Topic: General Client Board « Client Board

{Too Long!}

Posted to MB Topic: Just Conversation « PrestwoodBoards Board

{Too Long!}

Posted to MB Topic: General Client Board « Client Board

{Too Long!}

Posted to MB Topic: Tech Writing « Tech Writer Board

{Too Long!}

Posted to MB Topic: Just Conversation « PrestwoodBoards Board

{Too Long!}

Posted to MB Topic: Computer Industry News & Trends « Industry Board

{Too Long!}

Posted to MB Topic: ObjectPAL « Paradox Board

Hi I would like to have our delivery-note number as the report name, so when we print it with a PDF driver, the pdf attachement would have the same name as it corresponding deliverynote. In order words how would the syntax be for renaming the report before printing ?  Rgds Peter

Posted to MB Topic: Paradox Reports « Paradox Board

{Too Long!}

Posted to MB Topic: General Client Board « Client Board

{Too Long!}

Posted to MB Topic: General Client Board « Client Board

{Too Long!}

Posted to MB Topic: Just Conversation « PrestwoodBoards Board

{Too Long!}

Posted to MB Topic: General Client Board « Client Board

{Too Long!}

Posted to MB Topic: Paradox Forms « Paradox Board

{Too Long!}

Posted to MB Topic: Paradox Forms « Paradox Board

I have a query which I wish to populate a particular table (not the answer table). I have been unable to run this in objectpal. I think it has to do with the tilde variables but i'm not sure. following is my code. The variable are populated correctly so any advise is most appreciated. son = 22013, sol = 1  , qvar = Query Answer: :CaliachData:rptWorkorders.DB , WORKORDERS.db |WKOWONO | WKOPTNO |WKOBAL | WKOUSER | WKOUSE1 | WKOUSE2 | WKOUSER3 | WKOUSER4 |, , |CHECK | CHECK |CHECK | CHECK |CHECK ..~sol | CHECK | CHECK ..~son| CHECK | Endquery ExecuteQBE(qvar), tv.open(":CaliachData:rptWorkorders.DB") Thanks

Posted to MB Topic: QBE & SQL « Paradox Board

I need to use the contents of a parameter to pull a field's contents. Visual FoxPro uses the & character for that sort of thing. Is there a Paradox equivalent? Edit: Fount it - it's called dereferencing, eg  sField = "Name"   ;Assign a field name to the variable., view(tcCustomer.(sField));Dereference the variable using parentheses. from:  https://www.prestwoodboards.com/ASPSuite/KB/Document_View.asp?QID=101169

Posted to MB Topic: ObjectPAL « Paradox Board

Hi All, I‘m trying to change the first field in a table which has copied data from another table. I have tried using the following code but it does not change the last record. I have tried this code as a stand alone bit of code on another button on the form and it works. The variable as can be viewed and are correct Paradox  11 is the version. if not tc2.open(":caliachData:CopyWindingData.DB") then errorshow(), else while tc2.eot() = false, tc2.edit() if tc2.fldTrfWdgPartNum = oldpno then tc2.fldTrfWdgPartNum = cpno tc2.nextrecord() Endif, , endwhile, , Endif Thanking yo in advance Cheers Bill

Posted to MB Topic: ObjectPAL « Paradox Board

{Too Long!}

Posted to MB Topic: Paradox Forms « Paradox Board

{Too Long!}

Posted to MB Topic: Paradox Forms « Paradox Board

Is it possible to use a variable as a resulting value? Or is it only possible to use a variable as filter.  I would like the value in a variable to be put in the resulting column "DATETIMECHANGED". Thanks in advance, Gary var, todaysdatetime DateTime, custnbr String, qq Query, endVar custnbr = "1234", todaysdatetime = dateTime() qq = Query ANSWER: :PRIV:CHNGED.DB OPTIONS: NO AUXILIARY TABLES,ATA:Items.db | FILENO | CUSTNO |, | Check _join1 | ~custnbr | :DATA:PRICING.db | FILENO | QUANTITY | PRICE | DATECHANGED | REASON | INITIALS | PREVIOUSPRICE | PERCENTCHANGE | PRINTSELECT | LASTREFNO | SETUP |, | _join1 | Check | Check | Check calc ~todaysdatetime AS "DATETIMECHANGED" | Check | Check | Check | Check | Check | Check | Check |, EndQuery if NOT qq.executeQBE() then, errorShow(), else, endIf

Posted to MB Topic: QBE & SQL « Paradox Board

HI folks, I have the following code with a form;             exportASCIIVar(":RSA:Mailing Emails.db",":RSA:Reports\\Temporary Mail List.csv", "\t","\"",False,True), ,             MsgInfo("Well Done","The E Mail List for "+s+" has been updated.") S has been populated before this point, but I would like to replace "Temporary Mail List.csv" with a file name made up of the value of s, plus ".csv" Does anyone have any suggestion?

Posted to MB Topic: ObjectPAL « Paradox Board

If a variable that is declared within a method goes out of scope at the end of that method, is it really necessary to close a TCursor variable that is declared within a method?

Posted to MB Topic: ObjectPAL « Paradox Board

I need to be able to loop through a set of variables, say F1 through F3 using a for loop. To be able to do this I need something like this: f1 = "hello" f2 = "hi" f3 = "Goodbye!" for i from 1 to 3     msgInfo( "",  m.( "f" + string(i) ) ) endFor Where the variable name is constructed from its parts. The syntax for the evaluation here is wrong. What's the correct way? Pete

Posted to MB Topic: ObjectPAL « Paradox Board

I am developing an application that uses Crystal Reports as the reporting mechanism. But I am having trouble in getting Delphi to pass a parameter to the report. Does nayone have any suggestions? Thanks.

Posted to MB Topic: Delphi Object PASCAL « Delphi Board

Howdy, Is there a way to search for something (a variable name, for example) across multiple scripts (and each section of those scripts, like run, var, proc, etc.)? In the ideal world, I'd like the output to be something like:    script1.ssl   proc   1732   the line of code with the search phrase I suppose I might have to write my own script to do it - but was hoping for something easier. (My big project has code split across several scripts because of the size limitations built-in to Paradox.) Thanks, David

Posted to MB Topic: ObjectPAL « Paradox Board

{Too Long!}

Posted to MB Topic: ObjectPAL « Paradox Board

I need to use a (string) variable as a parameter for makeDir, but it only accepts a constant as a parameter. For example: n = 1 while n <4    stVar = "dirname" + string(n)    makeDir(stVar) endwhile How to get around this...?   Thanks! -pt

Posted to MB Topic: ObjectPAL « Paradox Board

I have a form which runs a query to select data within a specfied date range.  The form then opens a report based on the queried data.  Can I pass the start and end dates to the report in such a way as to display this range on the report?

Posted to MB Topic: Paradox Reports « Paradox Board

I need to use a (string) variable as a parameter for makeDir, but it only accepts a constant as a parameter. For example: n = 1 while n <4    stVar = "dirname" + string(n)    makeDir(stVar)     n = n + 1 endwhile How to get around this...?   Thanks! -pt

Posted to MB Topic: ObjectPAL « Paradox Board

Hi,, , How do you declare a variable in Paradox SQL and how does the section look for example?

Posted to MB Topic: Paradox Forms « Paradox Board

{Too Long!}

Posted to MB Topic: Paradox Third Party Software, DLLs, and Controls « Paradox Board

{Too Long!}

Posted to MB Topic: ObjectPAL « Paradox Board

I'm trying to select records based on date; if I do the following it works Aux = "Citas"

dbTable =  ":Citas:" + Aux TempFile = ":Citas:##Temp" + Aux SQLVar = SQL SELECT * FROM ~dbTable WHERE

(FechaCita < '01/18/2013') endSQL

SQLVar.ExecuteSQL (PacData, TempFile) but if I try to use a variable for the date comparison it gives me an error (Type mismatch in expression):    FechaMaxS = "18/01/2013" SQLVar = SQL SELECT * FROM ~dbTable WHERE (FechaCita < ~FechaMaxS ) endSQL I also tried the following but it gives the same error: SQLVar = SQL SELECT * FROM ~dbTable WHERE (FechaCita < CAST(~FechaMaxS AS DATE) ) endSQL Could anyone tell me the correct syntax?  Thanks

Posted to MB Topic: Paradox Forms « Paradox Board

{Too Long!}

Posted to MB Topic: ObjectPAL « Paradox Board

I have always had a problem with this and it has come up again so time to ask, am I missing something? I have a text object in a report with fixed wording and two embedded fields containing variable information. Fonts are all the same formatting (Arial 8 Regular) but the alignment between the fixed text and the embedded text is never correct in the final print out. The embedded fields align OK but not with the fixed text.... The result does not look neat. So am I missing something? Thaks, Paul.

Posted to MB Topic: Paradox Reports « Paradox Board

Hi: Can anyone tell me why the following header produces "Error: Type expected" on the DynArray variable? I'm using Paradox 11 but I tried it on another machine with Paradox 9 and it gave me the same error. 

method CalcTNRT ( N1P1Data DynArray[] AnyType) Logical