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!

Register Log in
  • Congratulations Rhinorhino 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. mlowe9

    Edge to edge printing not printing edge to edge

    Thank you!
  2. mlowe9

    Edge to edge printing not printing edge to edge

    I'm not sure if this is the correct forum for this. HP Laserjet 3015DN - HP Universal Print Driver. Edge to edge is turned on, but it's still cutting off right hand side of the form. Any idea why or any recommendations on fixing this? Thanks in Advance!
  3. mlowe9

    Return value in column based on subquery result

    That is absolutely perfect. Thanks!
  4. mlowe9

    Return value in column based on subquery result

    I have a select query with a subquery as a column: select name, (select count(*) from children), address, city from parents John, 2, 123 Johnson St, Chicago Fred, 0, 456 Jackson Ave, Chicago Mark, 1, 789 Jordan Rd, Chicago This is a dummied down version of what I need to do. But what I want...
  5. mlowe9

    VSS checkout w/batch file

    Does anyone know? Please?
  6. mlowe9

    VSS checkout w/batch file

    I am trying to setup a batch file to check out a file using the "Don't get local copy flag". Looks like this would be -L (or -L+ or -L-), but I can't get any of the flags to work. It tells me that it is not a valid switch. Can anyone help?
  7. mlowe9

    Run SQL script against an array of databases

    Outstanding. You guys are awesome!
  8. mlowe9

    Run SQL script against an array of databases

    Can I suppress the "(1 row(s) affected)" message caused by "insert into @db_name_table" lines? I only get it on text output, but that's what I prefer. Not a big deal, just wondering if there's an easy fix.
  9. mlowe9

    Run SQL script against an array of databases

    That's exactly what I was wanting. Thank you so much.
  10. mlowe9

    Run SQL script against an array of databases

    Thanks guys. Still not quite what I'm hoping for. The sp_MSForEachDB seems to be closest to what I'm wanting, except that I'd like to be able to define the databases I run the script on, instead of running it on ALL databases. There may be 10 databases on the server, but I only need to run...
  11. mlowe9

    Run SQL script against an array of databases

    Please let me start by saying I really don't know the syntax for SQL scripts when it comes to variables, loops, etc., so my example code I'm sure isn't close to what I need. Could someone share with me the syntax to run a SQL script against an array/list of databases. So instead of doing...
  12. mlowe9

    copy subset of records?

    I did see it, but did not notice that you did the embedded sql with the join also. I saw the select and assumed you were giving me something I wasn't wanting. So I will take the blame on that one and give you a star as well. Sorry about that. If I'd looked at yours more deeply I probably...
  13. mlowe9

    copy subset of records?

    Thanks a million. Wasn't exactly what I needed, but definitely gave me the structure I needed with that embedded select statement.
  14. mlowe9

    copy subset of records?

    Thanks, but I messed up a little. I just want to update the original table, but change the records for "fred" to match what's in the table for "matt". I wasn't specific enough. I apologize
  15. mlowe9

    copy subset of records?

    current table: key formname userid fieldname x_coor y_coor --- -------- ------ --------- ------ ------ 1 form1 matt field1 1 1 2 form1 matt field2 100 1 3 form1 matt field3 200 1 4 form1 fred field1 5 50 5 form1 fred field2 500...
  16. mlowe9

    Read ASCII File in Clarion 6.3

    Beautiful. I think that's sufficient. I'll be back if I get stuck again, but this is what I was looking for. I was missing the database driver and the SET command. What exactly does the SET command do?
  17. mlowe9

    Read ASCII File in Clarion 6.3

    I am trying to read an ASCII file in Clarion 6.3, and I'm having a little trouble with it. I've tried 2 methods, one where I define the file using FILE,DRIVER('ASCII'... and one using the AsciiFileClass, but I can't get either to work for me. Could someone please give me some very simple...
  18. mlowe9

    .dtsx file association

    Indeed I did. And I'll also try out the command prompt using .bat files to see if I like it. Thanks!
  19. mlowe9

    .dtsx file association

    I had my .dtsx files built and I could run them by just running the .dtsx file. However, somewhere along the way, Windows (XP) has lost the file assocation for the .dtsx files, now I can't run them - I have to pull them up in Visual Studio to run them. What program do I need to point the...
  20. mlowe9

    Multiple instances of IDE

    Thank you so so much.

Part and Inventory Search

Back
Top