Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Other Programming > VBScript
|
VBScript For questions and discussions related to VBScript.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VBScript section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old August 9th, 2004, 02:24 AM
Registered User
 
Join Date: Aug 2004
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default how to unload the values from sql where

    Hi Pals,

         I am trying to unload the values in the sql anywhere table

   to a text file by using this command

         select * from tablename ># c:\testfile.txt

         i am writing this command in triggers, if i save the

  trigger it is showing an error, so how can i execute this statement

  in sql anywhere

Reply With Quote
  #2 (permalink)  
Old August 9th, 2004, 03:45 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

Check with the isql utility available to that version. It is command prompt utility that can take input parameter and write output to a txt file passed as output paramater.

I believe it should look something like

isql -Sserver -Uusername -Ppassword -Iinputfilename -Ooutputfilename

inputfile should contain the select statement followe bu GO keyword

outputfile would be created later.

Cheers!

_________________________
- Vijay G
Strive for Perfection
Reply With Quote





Similar Threads
Thread Thread Starter Forum Replies Last Post
unload crystalActivexreportviewer sen22 VB Components 0 April 27th, 2007 02:01 AM
can i unload assembly ? amirxy VS.NET 2002/2003 4 March 25th, 2006 07:35 AM
Unload the Form dpkbahuguna Beginning VB 6 4 March 21st, 2006 06:50 AM
Delay form unload coolcatjk Pro VB.NET 2002/2003 1 December 15th, 2005 09:58 AM
Excel Unload m_soeb General .NET 1 June 4th, 2004 04:25 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.