• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
cdbUsers table
#9
(04-21-2021, 05:36 PM)clarencemartin Wrote: the added tableID is not included in my table name.

this is the code that I used:
local tNewName, tOutputA, tProjectID, tTableID
put cdb_projectID(,USMDdata) into tProjectID
put "cdbUsers-" & "c1d46708-7c49-4183-99fa-3741ffa8ae5e" into tNewName
put "dd07bc8c-1ec5-473b-aabb-5271c60a9bb6" into tTableID
cdb_renameTable tTableID,tNewName
put cdb_tableName(tTableID) into tOutputA

what am I doing that is wrong?

Try the code below:


Code:
local tNewName, tOutputA, tProjectID, tTableID
put cdb_projectID(,"USMDdata") into tProjectID
put "cdbUsers-" & tProjectID into tNewName
put "dd07bc8c-1ec5-473b-aabb-5271c60a9bb6" into tTableID
cdb_renameTable tTableID,tNewName
put cdb_tableName(tTableID) into tOutputA


The output should be "cdbUsers-" followed by the project ID of "USMDdata".
  Reply


Messages In This Thread
cdbUsers table - by clarencemartin - 04-20-2021, 06:49 PM
RE: cdbUsers table - by Linda Lu - 04-20-2021, 11:46 PM
RE: cdbUsers table - by clarencemartin - 04-20-2021, 11:55 PM
RE: cdbUsers table - by Linda Lu - 04-21-2021, 12:24 AM
RE: cdbUsers table - by clarencemartin - 04-21-2021, 03:12 AM
RE: cdbUsers table - by clarencemartin - 04-21-2021, 01:12 PM
RE: cdbUsers table - by Linda Lu - 04-21-2021, 05:07 PM
RE: cdbUsers table - by clarencemartin - 04-21-2021, 05:36 PM
RE: cdbUsers table - by Linda Lu - 04-21-2021, 05:48 PM
RE: cdbUsers table - by clarencemartin - 04-21-2021, 05:53 PM
RE: cdbUsers table - by clarencemartin - 04-21-2021, 10:18 PM
RE: cdbUsers table - by Linda Lu - 04-21-2021, 11:09 PM
RE: cdbUsers table - by clarencemartin - 04-21-2021, 11:33 PM
RE: cdbUsers table - by Linda Lu - 04-21-2021, 11:45 PM
RE: cdbUsers table - by clarencemartin - 04-21-2021, 11:52 PM
RE: cdbUsers table - by Linda Lu - 04-22-2021, 12:28 AM
RE: cdbUsers table - by clarencemartin - 04-22-2021, 12:45 AM
RE: cdbUsers table - by Linda Lu - 04-22-2021, 01:09 AM
RE: cdbUsers table - by clarencemartin - 04-22-2021, 01:12 AM
RE: cdbUsers table - by clarencemartin - 04-22-2021, 03:10 AM
RE: cdbUsers table - by Linda Lu - 04-22-2021, 07:51 PM
RE: cdbUsers table - by clarencemartin - 04-22-2021, 08:05 PM
RE: cdbUsers table - by Linda Lu - 04-22-2021, 08:20 PM
RE: Disappearing Files and Folders - by Linda Lu - 04-24-2021, 01:09 AM
RE: cdbUsers table - by clarencemartin - 04-24-2021, 03:40 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)