Tip Bank

DevX - Software Development Resource

Cumulative Summary in SQL

Question: I need a summary-select which summaries cumulative values. This one works in Microsoft Access: SELECT s.nl_item_id, s.nl_value, ( SELECT sum(sub.nl_value) FROM TABLE1 sub WHERE sub.nl_item_id

DevX - Software Development Resource

Convert Delphi to C++?

Question: How can you convert Delphi to C++? Answer: I don’t know of any conversion tools out there that do this, though I could be wrong. If you’re using both

DevX - Software Development Resource

Directory Browsing

Question: When the browser is pointed to a directory with no default HTML page then, in most cases, it shows the directory contents. Is it possible to create an HTML

DevX - Software Development Resource

Paradox Lock Files

Question: I have a Delphi 3 application running on a Novell network, that uses Paradox tables. For some reason, some of the users get the following message every once in

DevX - Software Development Resource

Passing Collections Between ASP Pages

Question: I am generating Active Server Pages using Visual InterDev and VBScript. I have fetched all my records from the database through my ActiveX DLL into a collection variable. Can

DevX - Software Development Resource

Undeleting Records from Paradox Tables

Question: How can I undelete a record from a Paradox table? Answer: You can’t. Period. When you delete a record from a Paradox table, its space still exists, but its

DevX - Software Development Resource

Typecast Text to LPARAM

Question: How do I typecast text to LPARAM? LPARAM is supposed to be an integer, but clearly the API call wants text. I’m assuming I missed some pchar>string or pointer

DevX - Software Development Resource

Troubleshooting Setup.exe errors

Question: I am trying to create a setup.exe for VFP 5.0, using the setup wizard. After I installed the application using the setup.exe and ran the program, I got error

DevX - Software Development Resource

String to Float

Question: How do I add two label values together and submit the answer to another label? Label19.Caption := FloatToStrF(Table1Standard.AsFloat,ffCurrency,15,2)Label20.Caption := FloatToStrF(Table1Zero.AsFloat,ffCurrency,15,2)Label21.Caption := StrToFloat(????????? Answer: This is one of those things