Thread: No consigo cargar un atributo do tipo Image de una DB SQL

No consigo cargar un atributo do tipo Image de una DB SQL

31/03/20 03:28

fcoartigas@gmail.com

Replies: 0

<p>Alguien pode me ayudar, ese tipo de Dato Image no deberia recebir un valor automatico the path o URL e cargar la image en el atributo?</p>

<p>No encontre nada en la documentacion, internet o forum, solo ese link que no descrebe nada:</p>

<p><a href="https://wiki.genexus.com/commwiki/servlet/wiki?15204,Image+data+type">https://wiki.genexus.com/commwiki/servlet/wiki?15204,Image+data+type</a></p>

<h1>Server Error in &#39;/Test.NetEnvironment&#39; Application.</h1>

<hr />
<h2><em>Invalid column name &#39;img_producto_GXI&#39;.<br />
Statement(s) could not be prepared.</em></h2>

<p><strong>Description:&nbsp;</strong>An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.<br />
<br />
<strong>Exception Details:&nbsp;</strong>System.Data.SqlClient.SqlException: Invalid column name &#39;img_producto_GXI&#39;.<br />
Statement(s) could not be prepared.<br />
<br />
<strong>Source Error:</strong><br />
&nbsp;</p>

<table style="width:100%">
	<tbody>
		<tr>
			<td><code>An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.</code></td>
		</tr>
	</tbody>
</table>

<p><br />
<strong>Stack Trace:</strong><br />
&nbsp;</p>

<table style="width:100%">
	<tbody>
		<tr>
			<td>
			<pre>
<code>
[SqlException (0x80131904): Invalid column name &#39;img_producto_GXI&#39;.
Statement(s) could not be prepared.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +3318656
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +334
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean&amp; dataReady) +4289
   System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +89
   System.Data.SqlClient.SqlDataReader.get_MetaData() +101
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) +624
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task&amp; task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) +3392
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task&amp; task, Boolean&amp; usedCache, Boolean asyncWrite, Boolean inRetry) +725
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +84
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +312
   System.Data.SqlClient.SqlCommand.ExecuteReader() +142
   GeneXus.Data.GxSqlCursorDataReader.CursorPrepExec() +766
   GeneXus.Data.GxSqlCursorDataReader.LoadFirstBlock() +484
   GeneXus.Data.GxSqlCursorDataReader..ctor(IGxConnectionManager connManager, GxDataRecord dr, IGxConnection connection, GxParameterCollection parameters, String stmt, UInt16 fetchSize, Boolean forFirst, Int32 handle, Boolean withCached, SlidingTime expiration, Boolean dynStmt) +484
</code></pre>

<p>Despues de mucho tiempo y efuerzo consegui integrar una DB externa (SQL Server) - DataStore2 en Preferences de Genexus 16. De la tabla que logre integrar es posible verificar todos los atributos do tipo Num y VarChar, pero cuando tento usar un atributo do tipo Image, que recibi de la DB una URL en formato: https://tatauy.vteximg.com.br/arquivos/ids/162903-1000-1000/CAPPUCCINO-TRADICIONAL-SAINT-200-U-1-6622.jpg,GENEXUS genera el seguinte error:</p>

<p>Alguien pode me ayudar, ese tipo de Dato Image no deberia recebir un valor automatico the path o URL e cargar la image en el atributo?</p>

<p>No encontre nada en la documentacion, internet o forum, solo ese link que no descrebe nada:</p>

<p><a href="https://wiki.genexus.com/commwiki/servlet/wiki?15204,Image+data+type">https://wiki.genexus.com/commwiki/servlet/wiki?15204,Image+data+type</a></p>

<h1>Server Error in '/Test.NetEnvironment' Application.</h1>

<hr />
<h2><em>Invalid column name 'img_producto_GXI'.<br />
Statement(s) could not be prepared.</em></h2>

<p><strong>Description: </strong>An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.<br />
<br />
<strong>Exception Details: </strong>System.Data.SqlClient.SqlException: Invalid column name 'img_producto_GXI'.<br />
Statement(s) could not be prepared.<br />
<br />
<strong>Source Error:</strong><br />
 </p>

<table style="width:100%">
<tbody>
<tr>
<td><code>An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.</code></td>
</tr>
</tbody>
</table>

<p><br />
<strong>Stack Trace:</strong><br />
 </p>

<table style="width:100%">
<tbody>
<tr>
<td>
<pre>
<code>
[SqlException (0x80131904): Invalid column name 'img_producto_GXI'.
Statement(s) could not be prepared.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +3318656
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +334
System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4289
System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +89
System.Data.SqlClient.SqlDataReader.get_MetaData() +101
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) +624
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) +3392
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) +725
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +84
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +312
System.Data.SqlClient.SqlCommand.ExecuteReader() +142
GeneXus.Data.GxSqlCursorDataReader.CursorPrepExec() +766
GeneXus.Data.GxSqlCursorDataReader.LoadFirstBlock() +484
GeneXus.Data.GxSqlCursorDataReader..ctor(IGxConnectionManager connManager, GxDataRecord dr, IGxConnection connection, GxParameterCollection parameters, String stmt, UInt16 fetchSize, Boolean forFirst, Int32 handle, Boolean withCached, SlidingTime expiration, Boolean dynStmt) +484
</code></pre>

<p> </p>
</td>
</tr>
</tbody>
</table>

<p>  </p>

Back to gx-l