Oct-13-2020, 10:29 AM
Hi Larz,
I need in this format when we have a single record and do not need loop
Local_id = pd.read_sql_query('select ISNULL(max(Id),0)+1 from firstTable', conn)
Local_id
# =============================================================================
# Now Select One value from the DB to local variable
# and setting up few columns those are not from Data File
# =============================================================================
oLid=Local_id.loc[0]
oLid
I need in this format when we have a single record and do not need loop
Local_id = pd.read_sql_query('select ISNULL(max(Id),0)+1 from firstTable', conn)
Local_id
# =============================================================================
# Now Select One value from the DB to local variable
# and setting up few columns those are not from Data File
# =============================================================================
oLid=Local_id.loc[0]
oLid