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 Mike Lewis 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. marvin2010

    how to Print a document on another network

    The printer you want to print on should be, at first, shared over the network. Once shared, you must add it on your printer list (control panel-> printers and faxes (in XP)). Then when printing, choose that printer.
  2. marvin2010

    SQL Syntax in SQL Server and Powerbuilder connectivity

    @WhoWantsTacos, Thanks. Appreciate the tip. :-)
  3. marvin2010

    How to set a particular data to all the rows in column

    Try the SQL Script UPDATE: UPDATE table_name SET column1=value, column2=value2,... WHERE some_column=some_value In your case, UPDATE table_name SET C1=12345
  4. marvin2010

    How to set a particular data to all the rows in column

    Can you please explain further?
  5. marvin2010

    SQL Syntax in SQL Server and Powerbuilder connectivity

    Hi Matt, Is that so? Oh my...kinda hard.... Thanks a lot for the thought. Appreciate it.
  6. marvin2010

    SQL Syntax in SQL Server and Powerbuilder connectivity

    Please help. I am trying to connect to two databases (with several tables connected to each other) in Powerbuilder 9.0 using MS SQL SERVER 2008. In SQL Painter (Design Mode) in PB, only one active connection is seen. How can I do the design of the tables when I need to use two database...
  7. marvin2010

    Copying Datawindow

    Did you check on the datawindow object the script under the constructor event the following?: this.settransobject(sqlca) this.Retrieve()
  8. marvin2010

    PB Windows 3.1 Version

    You could try to install it then just uninstall if it will not work...
  9. marvin2010

    Help with setfilter syntax

    Hey Matt, Sorry for the late reply. Just want you to know that the tip you gave did work. Again, am thankful...
  10. marvin2010

    Help with setfilter syntax

    Please help me the the syntax: ls_filter = "caller_id not like '" + "NAC" + "%'" + " and caller_id not like '" + "CI" + "%'" because I keep on getting the "expecting true/false expression" thanks!
  11. marvin2010

    Help in Retrieve and Filter syntax for Multiple Database/Columns

    Thanks, Matt !!! Appreciate it...
  12. marvin2010

    Help in Retrieve and Filter syntax for Multiple Database/Columns

    Hi Matt, A follow-up question re this... In the format you gave, "ls_filter = "city = '" + ls_city + "'" is it possible to get the first three characters of the ls_city and that all records matching that will be filtered out? Thanks!
  13. marvin2010

    Help in Retrieve and Filter syntax for Multiple Database/Columns

    Can someone please give me a format of a filter string that will have access to multiple database and tables? I am to access 2 database and several tables to come up with a single report. I need to filter out some columns as the program needs to be able to allow the user to select if he wishes...
  14. marvin2010

    How and where do you trap errors in PB7 (ie, GetLastError())

    Have you tried regenerating the objects?
  15. marvin2010

    Computed Column vs a defined column

    Oh I see...but I think what I should have said was a COMPUTED FIELD rather than a COMPUTED COLUMN...Computed field because I clicked it on a datawindow painter and not it SQL... Also, I was trying to assign whatever value that is in the computed field (which is an amount) to a named column. It...
  16. marvin2010

    Computed Column vs a defined column

    Hi. Can you please help me? I have a computed column that divides in two a certain column in a table. I then added a specific column to also do the same (w/c is divide that column the computed column is also dividing). But when I do compare the result of the two, there are discrepancies in the...
  17. marvin2010

    Creating a DW column dynamically.

    Maybe this might help: http://pbbraindump.wordpress.com/2008/05/26/dynamic-datawindows/
  18. marvin2010

    Datawindow Print

    You can print on the same page if you would use the FREEFORM presentation style and arrange your columns accordingly. You could also check if there are extra columns under the DETAIL section of the datawindow that are already out of the printing area. You could also adjust the Left and Right...
  19. marvin2010

    PB 9.0 with Oracle 10g database

    @mbalent, I am not sure about that because our DBA handles the database stuff...Maybe I should ask him then? Thanks. :-)

Part and Inventory Search

Back
Top