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: Fleer
  • Order by date
  1. Fleer

    SQL Statement "on the fly"

    Hi Jhall01, I had about the same problem as you have now, what I did was creating a table called fields (or whatever you like) and added fields like fieldname, showname, length, sortorder, etc... so you could get a table looking like this : FieldName - ShowName - Length - SortOrder fname -...
  2. Fleer

    Error when looping through array

    In reply to your last post here, you're not a doofus :) You gave me some great assistance, thanks for the help. The first character of my field names begins with the field type, so the n and d stands for Numeric and Date.
  3. Fleer

    Error when looping through array

    I fill up an array (Session.myArray) with finds users make in my database, when they hit submit I generate my query based on the values in the array : the values in the array are [x][1] : FieldName [x][2] : Symbol (=, >, LIKE, <=, etc) [x][3] : string or value entered by the user [x][4] : 'And'...
  4. Fleer

    relational find

    This should work, however instead of using Perform Find you can do the following : Enter Find Mode[] Insert Calculated Result[Select, FieldName, Value] Perform Find If there are any other fields in your find, specify these in your 'Perform Find'(checkbox 'Restore find requests') or you can...
  5. Fleer

    Invalid column number when updating my record

    Hi Guys, I've created a dynamic form and I added a submit button to save the updated data. I've used <CFUPDATE> because I don't know wich fields will be in the form (this is based on certain chooses the user makes). <cfupdate datasource=&quot;Myconnection&quot; tablename=&quot;DBname&quot...
  6. Fleer

    can filemaker solutions be comercialized ?

    With the developer edition of Filemaker you can create standalone runtime applications that can be run without having FMpro installed, these are royalty-free and can be sold by you, however all these applications are single user.
  7. Fleer

    Upgrading FMP V5.03 to V5.5 for Windows

    The latest version is 6 and It is not free you will need to purchase a upgrade, on the Filemaker website I can see that the upgrade cost $149.00.
  8. Fleer

    Loop exiting

    a loop is always build like this : go to record/request/page [first] loop ... go to record/request/page [Exit after Last, Next] end loop so in order to stop the loop when it reaches it last record, you must always choose 'next' from the specify pull down menu and then a check box will appear...
  9. Fleer

    XMLTOCURSOR() FUNCTION

    Hi experts, In VFP7 there's a function to convert a XML file to a cursor or table, can someone explain me how this is to be done. If possible with an example. I checked the help about this function but can't figure out how it works. Thanks Fleer
  10. Fleer

    Excel Question

    I created an excel application in VFP, but I can't find out how I can insert a Horizontal Page Break in my XL-file this is an example prog. PUBLIC poxlApp poxlApp=createobject(&quot;Excel.Application&quot;) poxlApp.Workbooks.Add poxlApp.Range(&quot;A2&quot;).Select and then to insert the...
  11. Fleer

    Textbox uses Enter key not work

    If you want to go to the next textbox using the returnkey try something like this. In this example I have 4 Textboxes, I all named them Input. Once you reached the last Textbox, he will go back to the first one. Private Sub Input_KeyDown(Down As Integer, KeyCode As Integer, Shift As Integer)...

Part and Inventory Search

Back
Top