Hello all,
I have inadvertently deleted my Primary Request
form/schema
The good news is that there are backups BUT...
Restoring is not an options that the powers that be
want to consider.
Question. Is the underlying table still in existance?
I am very good at SQL and plan do extract all 600 or
less records from the table and then use the import
function to populat my table.
Feedback Please!

=====

Regards,

Linda Gage (415) 656-4470(415) 806-1461

__________________________________________________
Do You Yahoo!?
Yahoo! Photos - Share your holiday photos online!
http://photos.yahoo.com/

Yes - the underlying tables have gone

You could restore your backup to a dev system, then export the form you
want, either via Remedy, or at the database level. By that I mean do the
form via remedy, then get the tables out, H, T etc, drop them and replace
them with these.

Look at aradmin.arschema table to the the table ID, then find all the tables
that are Tnn, TnnCxxxxxxx, Hnn, Bnn, BnnCxxxxxx where nn is the table ID.
If you have no attachments, or long fields then you won't have any
TnnCxxxxxxxx or BnnCxxxxxxx tables.

Good luck!

Neil Anderson
Halifax plc (UK)


----- Original Message -----
From: "Linda Gage"
To:
Sent: Thursday, December 28, 2000 7:24 PM
Subject: Deleted Form


> **
>
> Hello all,
> I have inadvertently deleted my Primary Request
> form/schema
> The good news is that there are backups BUT...
> Restoring is not an options that the powers that be
> want to consider.
> Question. Is the underlying table still in existance?
> I am very good at SQL and plan do extract all 600 or
> less records from the table and then use the import
> function to populat my table.
> Feedback Please!
>
> =====
>
> Regards,
>
> Linda Gage (415) 656-4470(415) 806-1461
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Photos - Share your holiday photos online!
> http://photos.yahoo.com/
>
>
>

>

Great I will do this!
--- Neil Anderson
wrote:
> **
>
> Yes - the underlying tables have gone
>
> You could restore your backup to a dev system, then
> export the form you
> want, either via Remedy, or at the database level.
> By that I mean do the
> form via remedy, then get the tables out, H, T etc,
> drop them and replace
> them with these.
>
> Look at aradmin.arschema table to the the table ID,
> then find all the tables
> that are Tnn, TnnCxxxxxxx, Hnn, Bnn, BnnCxxxxxx
> where nn is the table ID.
> If you have no attachments, or long fields then you
> won't have any
> TnnCxxxxxxxx or BnnCxxxxxxx tables.
>
> Good luck!
>
> Neil Anderson
> Halifax plc (UK)
>
>
> ----- Original Message -----
> From: "Linda Gage"
> To:
> Sent: Thursday, December 28, 2000 7:24 PM
> Subject: Deleted Form
>
>
> > **
> >
> > Hello all,
> > I have inadvertently deleted my Primary Request
> > form/schema
> > The good news is that there are backups BUT...
> > Restoring is not an options that the powers that
> be
> > want to consider.
> > Question. Is the underlying table still in
> existance?
> > I am very good at SQL and plan do extract all 600
> or
> > less records from the table and then use the
> import
> > function to populat my table.
> > Feedback Please!
> >
> > =====
> >
> > Regards,
> >
> > Linda Gage (415) 656-4470(415) 806-1461
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Yahoo! Photos - Share your holiday photos online!
> > http://photos.yahoo.com/
> >
> >
>

> > To UNSUBSCRIBE, email the message "unsubscribe
> arslist" to:
>
> >
>
>

> To UNSUBSCRIBE, email the message "unsubscribe
> arslist" to:


=====

Regards,

Linda Gage (415) 656-4470(415) 806-1461

__________________________________________________
Do You Yahoo!?
Yahoo! Photos - Share your holiday photos online!
http://photos.yahoo.com/

Linda --

Your workflow associated with that form is gone too. Don't forget that! =)

-tony

-----Original Message-----
From: Neil Anderson [mailto:disturbed@FREEWEBACCESS.CO.UK]
Sent: Thursday, December 28, 2000 11:39 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: Deleted Form


**

Yes - the underlying tables have gone

You could restore your backup to a dev system, then export the form you
want, either via Remedy, or at the database level. By that I mean do the
form via remedy, then get the tables out, H, T etc, drop them and replace
them with these.

Look at aradmin.arschema table to the the table ID, then find all the tables
that are Tnn, TnnCxxxxxxx, Hnn, Bnn, BnnCxxxxxx where nn is the table ID.
If you have no attachments, or long fields then you won't have any
TnnCxxxxxxxx or BnnCxxxxxxx tables.

Good luck!

Neil Anderson
Halifax plc (UK)


----- Original Message -----
From: "Linda Gage"
To:
Sent: Thursday, December 28, 2000 7:24 PM
Subject: Deleted Form


> **
>
> Hello all,
> I have inadvertently deleted my Primary Request
> form/schema
> The good news is that there are backups BUT...
> Restoring is not an options that the powers that be
> want to consider.
> Question. Is the underlying table still in existance?
> I am very good at SQL and plan do extract all 600 or
> less records from the table and then use the import
> function to populat my table.
> Feedback Please!
>
> =====
>
> Regards,
>
> Linda Gage (415) 656-4470(415) 806-1461
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Photos - Share your holiday photos online!
> http://photos.yahoo.com/
>
>
>

>

Thanks...
I was creating a new form/schema to replace the one
that was working.
I needed to Rename the old form which went fine.
Next I needed to rename my newly created form to the
production name but I could not do that until I
deleted the original form. This worked fine too except
the results were MORE that I was looking for.

Next the DBA did not want to restore from backup
and the nightmare goes on.
Long story to say that the workflow was accounted for
within the modification.
--- Tony Worthington
wrote:
> **
>
> Linda --
>
> Your workflow associated with that form is gone too.
> Don't forget that! =)
>
> -tony
>
> -----Original Message-----
> From: Neil Anderson
> [mailto:disturbed@FREEWEBACCESS.CO.UK]
> Sent: Thursday, December 28, 2000 11:39 AM
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject: Re: Deleted Form
>
>
> **
>
> Yes - the underlying tables have gone
>
> You could restore your backup to a dev system, then
> export the form you
> want, either via Remedy, or at the database level.
> By that I mean do the
> form via remedy, then get the tables out, H, T etc,
> drop them and replace
> them with these.
>
> Look at aradmin.arschema table to the the table ID,
> then find all the tables
> that are Tnn, TnnCxxxxxxx, Hnn, Bnn, BnnCxxxxxx
> where nn is the table ID.
> If you have no attachments, or long fields then you
> won't have any
> TnnCxxxxxxxx or BnnCxxxxxxx tables.
>
> Good luck!
>
> Neil Anderson
> Halifax plc (UK)
>
>
> ----- Original Message -----
> From: "Linda Gage"
> To:
> Sent: Thursday, December 28, 2000 7:24 PM
> Subject: Deleted Form
>
>
> > **
> >
> > Hello all,
> > I have inadvertently deleted my Primary Request
> > form/schema
> > The good news is that there are backups BUT...
> > Restoring is not an options that the powers that
> be
> > want to consider.
> > Question. Is the underlying table still in
> existance?
> > I am very good at SQL and plan do extract all 600
> or
> > less records from the table and then use the
> import
> > function to populat my table.
> > Feedback Please!
> >
> > =====
> >
> > Regards,
> >
> > Linda Gage (415) 656-4470(415) 806-1461
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Yahoo! Photos - Share your holiday photos online!
> > http://photos.yahoo.com/
> >
> >
>

> > To UNSUBSCRIBE, email the message "unsubscribe
> arslist" to:
>
> >
>
>

> To UNSUBSCRIBE, email the message "unsubscribe
> arslist" to:
>
>
>

> To UNSUBSCRIBE, email the message "unsubscribe
> arslist" to:


=====

Regards,

Linda Gage (415) 656-4470(415) 806-1461

__________________________________________________
Do You Yahoo!?
Yahoo! Photos - Share your holiday photos online!
http://photos.yahoo.com/