hello all.
happy labor day!
can anyone suggest a script step which, when put in a portal row, will
change layouts in the current file and display data from the record whose
row was clicked?
thanks for any suggestions,
jax
by jackson harvel » Tue, 04 Sep 2001 12:26:42
happy labor day!
can anyone suggest a script step which, when put in a portal row, will
change layouts in the current file and display data from the record whose
row was clicked?
thanks for any suggestions,
jax
by PCC » Tue, 04 Sep 2001 12:35:53
on 9/2/01 8:26 PM:
Quote:> hello all.
> happy labor day!
> can anyone suggest a script step which, when put in a portal row, will
> change layouts in the current file and display data from the record whose
> row was clicked?
> thanks for any suggestions,
> jax
by Jame » Tue, 04 Sep 2001 13:12:59
PCC is correct, Go to Related Record will indeed do it, if the relationship upon
which the portal is based is a valid self-join relationship, meaning that the
records displayed in the portal are part of the same database. If not, you
could create another layout with fields from the same relationship reflected,
but you would have to create and manage a concatenated key value and a second
relationship to wind up with the right values displayed. That's too much
overhead for me, I just go to the child database and view the data there, then
return. Keep it simple if at all possible.
Hope that I understood correctly, and that this suggestion is helpful.
Best of Luck -
James
> on 9/2/01 8:26 PM:
> > hello all.
> > happy labor day!
> > can anyone suggest a script step which, when put in a portal row, will
> > change layouts in the current file and display data from the record whose
> > row was clicked?
> > thanks for any suggestions,
> > jax
by jackson harvel » Wed, 05 Sep 2001 04:19:26
i took your advice and simplified by putting the information i wanted to
show on a layout in the related database. that way i could just use a cinchy
"goto related record" step.
thanks!
> Hi jax -
> PCC is correct, Go to Related Record will indeed do it, if the relationship
> upon
> which the portal is based is a valid self-join relationship, meaning that the
> records displayed in the portal are part of the same database. If not, you
> could create another layout with fields from the same relationship reflected,
> but you would have to create and manage a concatenated key value and a second
> relationship to wind up with the right values displayed. That's too much
> overhead for me, I just go to the child database and view the data there, then
> return. Keep it simple if at all possible.
> Hope that I understood correctly, and that this suggestion is helpful.
> Best of Luck -
> James
>> How about GotoRelatedRecord?
>> on 9/2/01 8:26 PM:
>>> hello all.
>>> happy labor day!
>>> can anyone suggest a script step which, when put in a portal row, will
>>> change layouts in the current file and display data from the record whose
>>> row was clicked?
>>> thanks for any suggestions,
>>> jax
> --
> Don't forget to remove the obvious spam block when replying.
> I advocate making an address book entry and using it! Thanks!
1. SQL-DMO (Active script within job step) Problems with Script statement
I'm attempting to create job step that will create a single file for each
database on the server . Each file will contain the transact SQL statements
to completely regenerate the database. I'm trying to use SQL-DMO statements
active script (Visual Basic script).
this is the code I've arrived at.
*************************************************************************
dim scripttype
dim objServer
dim objDatabase
Set objServer = CreateObject ( "SQLDMO.SQLServer" )
objServer.Connect".","sa" ,"??????"
For Each objDatabase in objServer.Databases
objDatabase.Script SQLDMOScript_AppendToFile, "f:\dmo_test\" &
objDatabase.Name & ".sql"
print " DB " & objDatabase.Name
For Each objTable in objDatabase.Tables
objTable.Script SQLDMOScript_AppendToFile, "f:\dmo_test\" &
objDatabase.Name & ".sql"
print " TB " & objTable.Name
Next
Next
objServer.Disconnect
Set objServer = nothing
*************************************************************************** Currently the a file gets created with the Database name and script but gets Does any one have a sample of SQL-DMO code (Visual Basic Script) that uses I know I'm doing something stupid . I just hope that one of you gurus can Thank You Dave Gall 2. Problems with Full-Text Search 3. How to call a Visual Basic script from a FM script step 4. Copying a query to another query 5. Pasting a Script step into another Script... 6. Data Warehouse Methodologies 7. Importing Records Script Step...HELP 8. ALABAMA-DBA 9. Help!: Send E-Mail Script Step 10. Extracting log information for DTS Packages, Steps, and Error in a ActiveX Script 11. DTS ActiveX Scripting to find previously called step? 12. Execute step from ActiveX script 13. Sample Code for extracting package and step log info in ActiveX Script
***
cleared by the "objtable.Script" statement . The table name print confirms
that each table is being accessed.
the Script statement and the associated arguments as it would be used within
a job step.
help.
Title: Programming Leader
phone: (604)691-6481
fax: (604) 691-6237