pb with update database

Françoise

hi,

 

with jmp14, I've created a database with the query builder.

when I want to update the data base, there is no update.

I don't understand why.

 

If someone could help me...

//Beginning of the script for the update of the database:

New SQL Query(
	Version( 130 ),
	Connection( "JMP" ),
	JMP Tables(
		["Exploitation" =>
		"Source(Open(
	\!"S:\Guingamp\Commun\Fab\BDD Exploitation.xlsm\!",
	Feuilles de calcul( \!"Exploitation\!" ),
	Use for all sheets( 1 ),
	Concatenate Worksheets( 0 ),
	Create Concatenation Column( 0 ),
	Worksheet Settings(
		1,
		Has Column Headers( 1 ),
		Number of Rows in Headers( 1 ),
		Headers Start on Row( 4 ),
		Data Starts on Row( 5 ),
		Data Starts on Column( 1 ),
		Data Ends on Row( 0 ),
		Data Ends on Column( 0 ),
		Replicated Spanned Rows( 1 ),
		Replicated Spanned Headers( 0 ),
		Suppress Hidden Rows( 0 ),
		Suppress Hidden Columns( 0 ),
		Suppress Empty Columns( 1 ),
		Treat as Hierarchy( 0 ),
		Multiple Series Stack( 0 ),
		Import Cell Colors( 0 ),
		Limit Column Detect( 0 ),
		Column Separator String( \!"-\!" )
	)
))"
		]
	),
	QueryName( "SQLQueryGGP" ),
	Select(
		Column(
			"Semaine",
			"t1",
			Analysis Type( "Ordinal" ),
			Numeric Format( "Fixed Dec", "0", "NO", "" )
		),
		.....
		
		
		
		
		
		
//end of the script:
			)
) << Run Foreground( UpdateTable( Current Data Table() ) );

 

 

　

 

gzmorgan0

It is not clear to me what you are trying to do, what you are trying to update.  Your script has used a query to extract data from an XLSM workbook.

• Are you trying to update a table, opened prior to running this query with the extracted information?
• Are you trying to update current records  in the .xlsm from a table that is open or trying to change multiple records conditionally, for example UPDATE Customers
                                              SET ContactName='Juan'
                                              WHERE Country='Mexico';
•  ??

The JSL you shared is not creating a database, it is creating a JMP table.

-confused-