Re: how to export the result

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Newbie (noidea_at_nospam.com)
Date: 11/04/04 

Date: Thu, 4 Nov 2004 18:31:37 -0000

Thanks but could you explain a little with an example

I have created my UDT and I have my recordset - how do I do the next part?
"Jeff Johnson [MVP: VB]" <i.get@enough.spam> wrote in message
news:uXHIa7awEHA.2572@tk2msftngp13.phx.gbl...
>
> "Newbie" <noidea@nospam.com> wrote in message
> news:Of%23FMmawEHA.1308@TK2MSFTNGP09.phx.gbl...
>
> > I have a sp in SQL and I want to export the results to a Fixed Width
Text
> > file ( I can create a recordset)
> >
> > In Access I would simply right a little code to export the query using a
> > pre-defined specification.
> >
> > How can I achieve the same thing using VB?
>
> Create a user-defined type (a structure) with fixed-width strings. Open
the
> recordset, put the data from the current row into the UDT, write the UDT
to
> disk, move to the next record, and repeat.
>
>

Relevant Pages

  • Re: Update fields in previous row from fields in current row
    ... The data is in a csv file and imported into a recordset. ... If you look at the data, you can see that the first row has "00050-00-0" as the first field. ... Before my wife drags me off, my suggestion is to pull the data in one line at a time from the file, push it into a dynamic array of UDTs until your "total" line arrives, extract the data from that UDT and shove it into the spot you want it, in the first UDT. ... Save the current data (four lines in your example, less the last UDT array) ...
    (microsoft.public.vb.database.ado)
  • Re: Update fields in previous row from fields in current row
    ... I don't think i can "pull the data in one line at a time". ... The data is in a csv file and imported into a recordset. ... in the first UDT. ...
    (microsoft.public.vb.database.ado)
  • Re: implement Save button
    ... If you are using Connection.Execute "Update/Insert Into..." ... update the database. ... Your solution is fine and in this way you do not need to a recordset. ... You will use a UDT to recording the status of of controls on current form. ...
    (microsoft.public.vb.enterprise)
  • Re: how to export the result
    ... > In Access I would simply right a little code to export the query using a ... recordset, put the data from the current row into the UDT, write the UDT to ... disk, move to the next record, and repeat. ...
    (microsoft.public.vb.syntax)
  • Re: Simple Insert Into...
    ... The form is based on an SQL in the form's Record Source property, ... holds the current text in the control, ... Sometimes the unbound controls do have a value (such as when they are set ... I need this value to assign a unique ID to the entire recordset being ...
    (microsoft.public.access.modulesdaovba)