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

  1. Germancho

    Help with XMLAdapter

    VFP 8.0 SP1 Windows XP Pro I'm new using XMLAdapter and I need to create a XML file based on two cursors ('cabs' and 'pagos') and an XSD schema. Please help me to learn how to do this. I wrote this code: ...code to save records on the cursors... LOCAL oXML as XMLAdapter oXML =...
  2. Germancho

    How to handle concurrency

    Thanks a lot Mike Yearwood and Mike Lewis. Your answers really help me. A star for both of you. Germán Restrepo Bogotá, Colombia
  3. Germancho

    How to handle concurrency

    VFP 8.0 SP1 Windows XP Professional Buffering set to 5 MULTILOCKS set to ON I have a parent table (Invoices, PK: prefix + number) and a child table (Products, Normal Key: (prefix + number) with a one-to-many relation based on these common fields. The rules in the RI are set to Cascade...
  4. Germancho

    Anybody know how to freeze a grid column

    Hi Bill: Probably the property 'Partition' could help you to freeze the leftmost part of the Grid. Best regards, Germán Restrepo Bogotá, Colombia
  5. Germancho

    Problem with UNION SELECT not returning all results

    Stewart, I hope this help: Try UNION ALL (SELECT...) instead of UNION SELECT ALL... Germán Restrepo Bogotá, Colombia
  6. Germancho

    myVariable vs lcMyVariable

    Hola amigos: Para la mayoría de ustedes es difícil leer este mensaje en español; por eso la Notación Húngara nos facilita la comprensión de los programas como un lenguaje universal. Algo así como el idioma inglés: todos nos comunicamos mejor con el. Hello folks: It´s so hard to read this...
  7. Germancho

    Append from dbf question...

    Try this: LOCAL lcDbf lcDbf = dbf('captura_movs') select 2 use w:cu_servs append from (lcDbf) _screen.activeform.release Best regards Germán Restrepo Bogotá, Colombia
  8. Germancho

    can I program a case question?

    Try: IF YourField == UPPER(YourField) && All Uppercase ELSE && Mixed ENDIF Best regards Germán Restrepo Bogotá, Colombia
  9. Germancho

    Rethinking How BIG should MY.EXE become?

    Select Project --> Project Info --> Debug Info. Be sure the Checkbox is not selected. Best regards, Germán Restrepo Bogotá, Colombia
  10. Germancho

    Create dropdown list with data from database file

    Don't worry Ramón. You can not add users directly from the combo because the users table has more than just one field; probably you have userid, name, etc and only one of them is stored in the Value property. You have a form where you add users, don't you? The method Requery is used to refresh...
  11. Germancho

    Create dropdown list with data from database file

    Yes, there can be more than one Combo in a form. When you add a new user you can use THISFORM.YourCombo.Requery() to update it and see the new ones. Germán Restrepo Bogotá, Colombia
  12. Germancho

    Create dropdown list with data from database file

    Hi Ramón Let's go step by step. 1. In your form select DataEnvironment and add the users table. 2. Add a ComboBox object to the form. 3. Select the properties and set RowSourceType set "2-Alias" and RowSource set to the name of the table (users); then set the Bound Column to the number of...
  13. Germancho

    Including and displaying JPG files

    Tom, Is 'picture' a Memo field type or a General field type?. I think 'picture' could be a VFP reserved word. If you want to use APPEND GENERAL mypicture FROM (cJPGFile) LINK mypicture must be a General field type. Germán Restrepo Bogotá, Colombia
  14. Germancho

    How to replace comma in a field

    I mean YourString = STRTRAN(YourString, ',') Best regards Germán Restrepo Bogotá, Colombia
  15. Germancho

    How to replace comma in a field

    Try this YourString = STRTRAN(YoursSring, ',') Germán Restrepo Bogotá, Colombia
  16. Germancho

    Including and displaying JPG files

    Hi Tom I have a employees table with their photos. Try this code to add the .jpg file: LOCAL cJPGFile cJPGFile = GETFILE("jpg") IF !EMPTY(cJPGFile) SELECT Employees APPEND GENERAL Photo FROM (cJPGFile) LINK =TABLEUPDATE() THISFORM.Refresh() ENDIF Best regards Germán...
  17. Germancho

    SET CURRENCY TO

    No I can't. I write SET CURRENCY TO '$' and get the error too when I try to save. I don't understand what's happening. Germán Restrepo Bogotá, Colombia
  18. Germancho

    SET CURRENCY TO

    There is something so wired with myh VFP 8.0. I get an error even if I type SET CURRENCY TO 'Bs' directly on both LostFocus and Valid event, or anywhere into the form; writting the same at the Command Window works fine! Thank you. Germán Restrepo Bogotá, Colombia
  19. Germancho

    SET CURRENCY TO

    I think something is wrong with my VFP 8.0, I pasted your code and I still have an error. The SET CURRENCY TO lcCurrencyS is highlighted. Thanks anyway Griff, you're very kind. Germán Restrepo Bogotá, Colombia
  20. Germancho

    SET CURRENCY TO

    LOCAL lcCurrencyS lcCurrencyS = '"' + ALLTRIM(THIS.Value) + '"' SET CURRENCY TO (lcCurrencyS) It doesn´t work. I get the same error at developing time. Germán Restrepo Bogotá, Colombia

Part and Inventory Search

Back
Top