PC SOFT

PROFESSIONAL NEWSGROUPS
WINDEVWEBDEV and WINDEV Mobile

Home → WINDEV 25 → Gravar imagem em BD SQL Server com hexecuteQuery
Gravar imagem em BD SQL Server com hexecuteQuery
Started by Ananias, Apr., 06 2017 3:55 PM - 3 replies
Posted on April, 06 2017 - 3:55 PM
Olá, preciso de ajuda para gravar em um banco MSSQL arquivos do tipo imagem.
Não estou usando o Analysis. Estou usando desta forma:

s_cmdsql is string

s_cmdsql=[
Insert INTO ARQUIVO
VALUES (
%1,
%2,
%3,
%4,
%5,
%6,
%7)
]

s_cmdsql = StringBuild(s_cmdsql,"'"+sNomeArquivo+"'","'"+sMimeTipo+"'", "'"+sTamanho+"'","'"+sDataCadastro+"'","(SELECT * FROM OPENROWSET(BULK N'"+ "e:\uploads\" + TABLE_fiscal.NomeArquivo + "' , SINGLE_BLOB) AS conteudo)","'"+sIdentificador+"'","'"+sAcessado+"'")

Desta forma funciona, mas tenho que fazer um upload da imagem antes para uma a pasta 'e:\uploads\' no servidor.

Gostaria de saber uma forma de incluir direto na string o arquivo da imagem.

Poderiam me ajudar, por favor ?
Posted on April, 26 2017 - 10:31 PM
GRAVAR

declare @str varchar(max)

set @str = '/9j/4AAQSkZJRgABAgAAAQABAAD/7QCcUGhvdG9zaG9wIDMuMAA4QklNBAQAAAAAAIAcAmcAFFllWGl4ZFVFdmV0T3pWRGNSRGdFHAIoAGJGQk1EMDEwMDBhYzAwMzAwMDA2YjA3MDAwMDFjMGQwMDAwZTUwZDAwMDBhYTBlMDAwMDg1MTQwMDAwNjAxYTAwMDAzNzFiMDAwMDI1MWMwMDAwMGMxZDAwMDBlZjI0MDAwMP/iAhxJQ0NfUFJPRklMRQABAQAAAgxsY21zAhAAAG1udHJSR0IgWFlaIAfcAAEAGQADACkAOWFjc3BBUFBMAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAD21gABAAAAANMtbGNtcwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACmRlc2MAAAD8AAAAXmNwcnQAAAFcAAAAC3d0cHQAAAFoAAAAFGJrcHQAAAF8AAAAFHJYWVoAAAGQAAAAFGdYWVoAAAGkAAAAFGJYWVoAAAG4AAAAFHJUUkMAAAHMAAAAQGdUUkMAAAHMAAAAQGJUUkMAAAHMAAAAQGRlc2MAAAAAAAAAA2MyAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAHRleHQAAAAARkIAAFhZWiAAAAAAAAD21gABAAAAANMtWFlaIAAAAAAAAAMWAAADMwAAAqRYWVogAAAAAAAAb6IAADj1AAADkFhZWiAAAAAAAABimQAAt4UAABjaWFlaIAAAAAAAACSgAAAPhAAAts9jdXJ2AAAAAAAAABoAAADLAckDYwWSCGsL9hA/FVEbNCHxKZAyGDuSRgVRd13ta3B6BYmxmnysab9908PpMP///9sAQwAJBgcIBwYJCAgICgoJCw4XDw4NDQ4cFBURFyIeIyMhHiAgJSo1LSUnMiggIC4/LzI3OTw8PCQtQkZBOkY1Ozw5/9sAQwEKCgoODA4bDw8bOSYgJjk5OTk5OTk5OTk5OTk5OTk5OTk5OTk5OTk5OTk5OTk5OTk5OTk5OTk5OTk5OTk5OTk5/8IAEQgAwwEDAwAiAAERAQIRAf/EABsAAAEFAQEAAAAAAAAAAAAAAAQAAQIDBQYH/8QAGQEAAwEBAQAAAAAAAAAAAAAAAAECAwQF/8QAGQEAAwEBAQAAAAAAAAAAAAAAAAECAwQF/9oADAMAAAERAhEAAAHltDI7QOdv2Tw5YnqBEYFfZxDiCOuuZwBmj0gcJZ1ogc+N6By4Z8eycORD7LAAQ3frkwg+ovDkX63Qo4CHZWhxce1qDkcn0PzQNi0e/DjxtbIfbs0j+edm0TzZsvbHzLgs1SCaWZPUgGOtTPThnd5mhz0uk5lqA3ZlhxZWqWjlm6O8OVeGGzffnkHQ14SDfwEg1L6L8OPGTtt2OkhIwM2bYwKpHW2xz9J1IhGqisXTEl6gIIkvWzgaanqiOKZraP5e1Pqaedzmt3n3ZpJIEkhJJD1L6L8ePHSfbrSZAxoRc3JmsJ6sbSCqrNLKKnSARw2GmdTpjTYdJlNoOkoXXnVlVqTgHBMgk1w6tmmOimAZiWAy+qzHjyElv1JnYEWIXNrZxthrpGLvqgZEVYbjDXw5tqBSxnQgxYWuVcJTuQpzjWV+Zq5LVVld1ZaFzWcvTFSUkVNBUpNPn4qS79kzoGtpQyDslxelF4uzVWCG0Y9AY7W8u4+Sdg3MbzKLkUiBDA4WwqHzDs2skYHoOTJxly9DpKRJ0FaSnzsRJehskkCjJgik49Ts/O+2Doc4+pa52nHBw0yRxT6uucrZqUrITQULa7xGA0QNuZtPO0s6vsrnz7pJA6ZAzJp87FSfv2Z0wM7IHSQPoXd0qlCjk8dli2bFGZpBErWLQJQra7JdFRI9ZjBnZuvO+rkXp6zgTx1OQSGYgoiNVE8+DKTP27pnQQTob309CHY0F8xjvlZpOiAd7Cq674kOURROXS1hTJDaACjOzTA98mSVJJJCSQOzszUvovw48d2W3W6SbUpXNLsuN9FCfJ9XyvL1CHBGDHrfqtc+TF63PSHtJlz7jWs7l8U3B1wGgn2zZ1IbPKQoJ2bZpJGhfRdhx47s2/W7xkwxaHR3PH+g4e1Fg4e1qZacGR0FVHOa3Sg3nTcRGlRmHtleNHo+cTyAfVONqOdn6GZR5bPvag4lejecIdO4otOIH2V24cmMnl0dkTqdO4j1kbooDazczDTS2fPBNp7izz+tr1LP4wkXXSyYxZKx8h16Dlcmqz9I5DHpD0IvzC1HocPP4h6R5hdWDvBCZpxDQtqtw5IPYgg84UzS8m6VdTCPPtBpS6M6Y3M5a+uaL664zpKq1lVcbWvGtrkFE5SCuNzBXAiIVvY4UK5BB1LHH//EADAQAAICAgAEBQMCBgMAAAAAAAECAAMEEQUSEyEQFCAxMxUiMCMyJDQ1QENFJUFC/9oACAEAAAEFAutbManMyYRli/y+b13ozUrsx82it6cwO2NnC1qs1UsxM+uqhMu9PJ5/M1GcqXYufSnlM/mqrzLkGJntDi56wYXECa68yy44+dW64+chenNNhxs7rPi56Hymf1Ex857OhmwY+cWuoz6ZfjZ1NfXulbsUM4f/AEjP/rn++/wZb3B2XecQTfmBei/ycC5fKdvNj4cp7g2T/L8C7zes3G/VrR1ZODa+pN3g6f1bHNfmK/e79pZeenYurUJlkcuf/hyfglPxzDz7MZHzLHy34tabL+JW2y7iNt1f1W4MnF7lV+I2PR5+25FfytTZlnNfm2WS3iNlyfVbepjZJxbfqNnmsfidtMo4nZVKc5qsteKWaHFLGsXLfHu+qWdf6rZynitu24tbqzi1lgPFretdxS60ZHFLLqpT8fpSPOGJz5/Ga0arHNWNh4K0iYyKMmkI/EuLhVvautrMKtK8WmqtIwru4ploj0CuvzGNeGw8MCzFx66q0FVSZPFyDkeun4/QIsecKtrpy8nIqyMSm7H8umbjrUbsWzIOdj9TiF1eRX57E6mJl0eXrysWyzJyq24jlZuN0RxDFMx8mtcDHy6UxkzMdo2Xi35PGMiu9/XT8fpSPKV3a+guzETmIpVYwUgjUbtG7xlmpqe094seN+Gn4/QIvs/tj/NcWE1uU9iRqPqMdxu80ZqEQif9xTGOwfw0/H6BB7MdjCXmybhucpEQT7jCu4UBhScsIjCEQ+CDcaN4hdzpzpTpTpTpmVr9noHuIZwmkm+4ksKyYtepy6hEI1CPFvAjY1qKftIAqfwQbiLNeGpqamvSIPacMflvI3F7xu3gfczW5ox2UQtN78GiDbW/aH8KhF/H7TmnNMO0V5PvE7hhDGM9ox1Lr2E+95yaC/u1oEbg7Gw7VvCoQdh+UdpgX9Wms6hO4R2dwDUOeZbdNnbbVFeW0iINQjQhG4x3X7+FQ/sMC7pXKTzal9/LKcUlmPIubcXbXbl3Amog1H8bDqe0Er7f2A7TEes0g7grALuusrK0A/PdAYOUwdo534v3hGivukH9hhV2W3KvLHt5RlZJ53LOa15Yq7hGin3HZEI1DDDHOyDqIdgfjPo4fhnKemquhb7wkyctmiAuwqUKT3V9RzzEdvAHYYahEfsPBG5Z1Z1Z1Z1Z1Z1Yr9vXTW1tlFK013Wcoyb2sYjcpHJGfUr7wJuU19yuo9m4jERhsMO1vYfhp+P18DX+LsblGYWMI7rWApXYc6CDSqVnU79NzAqiKs1tX7S8/ip+P063AgE4LXqm32yn5jUvcRuxFDWBl0FTZTtOTmnIBEWWfbLmjHZ8NTU16NSn4/Qg3EEYzCTp4dx+28d6+zSzvKqgldlKkHH1ApAjd4O0sfQtffpA9VXx+hV1S7KJioLLjlUCW5VRN19ZnUUN1U5RahOJk2dOvPodRk0c2RZUgN1c69cOQurLw0JgImwISIO82PVX+z0VkNTgErwzHG8vohLO3080DzmOFpxGbHs4iir16mavheMoswXQV8N4WwsbGZ7uIZCqcrjA/wCRya1fH4F/OW09OjCRVxcT9Dh/EaEbI4kivhDv6N6lXx+AiLqVVuz4aWDhtW/Ni3qL/rls/iMfmODlnlzNcj1i48LoLV4uQ3Nj8HXlbhTvc6Kj1Z2M7cTHTOTwVeTiNtnW4eeRbXpJxrxvK0rwe3hvc1uVfs1NSlOZtCcJrAXKxV5RUnTuRUjFtGx9pZYkJd51HavBD2N0FhrRBadTbrA9gXqWTqPvnZSLLJ1LJ1bp1H2LbAfabmtzWpvUq+MVrORYEWLKsm6pDm5ES+wCx2MMZF3yLORYVGq/04LrI9jOn/nlE5FnIs6azprBWs6azprDWs6aw1rOms6aw1pOkkAGv//EACARAAICAgIDAQEAAAAAAAAAAAABAhESMRAgAyEwEzL/2gAIAQIRAT8B4v7PfKH9XvmJIRRRgYlFDVdXvmIyKMCPjMBxJIiT4oooe+YjIkeWzZXs8gtiXMt9YkGXQ2Y+iKJHkI76S31QhCEuJjIdJb6pC9H9EPRZkTGRdGRkjIlL31gisjRYo2Yj7PfSJHRE8kqIyLGS7PfRej9D9CTsRk0Zd3vhsiYFVwhRH46+D2W+LZkxtlsi2JsnJ0Wy2Wy2Wy2W+P/EACMRAAIBBAAHAQEAAAAAAAAAAAABAhAREjADEyAhMTJBIkD/2gAIAQERAT8B1NXEraGL+CRCrdjMyo5WFK+iRAY5WJTLiExohS6MkZLokQGTLiI0+EB+BvrQyauNEIl6xJ+NTLniqInE0sbuz1HSxEiSjcwZgzlsx6eI/h6nmly/YiLU/YZw4XJRtWC0IfanL7mAvyZDgmcstoiiUjmi708GRlqjT6RpKi0//8QAOxAAAgEDAgMFBAgFBAMAAAAAAQIAAxESITEEEyIQIDJBUSMwM0BSYWJxc5GSoUJygbHBFGOCwoOy0f/aAAgBAAAGPwL4tT9RhNN3sPPOcgvU5h8sjORk3MtfxzMs9r4+PznMctYb9e0Sndsn8PtIlMs2bajrjOXeytievznMLPYfb1jvTd8V364Fya5Fx7SBy72Y28czZ2t/PMMmva/xI7I7WTfriWdurUe0i3Zuo2HtIbM2m/tI1FXfNd+uKhL3fQdekC2Nz/uTCzBiPp6QUsnyO3XvFDF+o2HXAmTZEX+JHpq7Zpv7SVBm/s/F1xVDtdlyHtPKDI1NTpZpzHd8R9vafGqfqMBLt+fZ/wCUf+wnD/0h/ClL8f8AzOKVKYdMeolttJwx+jTacK7CzdQlx51lP7zifwx/mcRl4fOUfwzOG/G/+zilSmGQ+JsttJUw8eEr0/Vbzh6f0aRn8lZv7zji7ELnYkb7SpiSVxO+84bDw807/wBZYO5fE5L5CcXg7Nprfy3nAfyf4lPDbn63mXmDhOLcC5NQf2nFE7NjOHUbCkw/tKX4/wD2nH/d/wBewdhp4B0vsfKDiWAyGwiuEQFYllWni2WkdBTRM92gbl09BbzigojY+es5WIHVleFSKaZDV46U+XhUHmYlS9MFBYfXEPs6YQ5C0KBEXLxEGZY09rWvDUTHX+Gf6jGnfHG14+KI2TZecqdCNzGyN4/EBFu3lEGCdLZQPhRDD649YYHmeJfKJUwUBBosty08ecPQvjyjgIoyN7i8cctBmLRanLS6i0WyKmLZaRqeCrl4j2D3FIHUXvKTIAOu04UsExqeIn7pXcYtTNSyzjFAXm3ut45NHl4U9QwlNlAs6zkmkmJS+0o2QHmNZriV1oohqB9jFTlmmpazIZxC4L7Pw6RRgvw/SVqvJp3pXG0ovyqfV4tJWqU1X4ttZWFNU5pW63g9iaTAa/X7ge45lVsQF0hVdGzuBacOtZ8eV5Ebw2A1qXxtKjZ2LAY1LbR2y/httvKBpnqXcekz5uoW1rSmtV+WabX2lR2PKfLpe2pESumqJaV+XUzap5QVuZ1BbYW1nE03ezuTYThUNSxQ9UrI1TAF8g3rKt2x06KnpKfKbLEan3A9wv3zyH9JabTWbD5Qe4S294Jr27fKD3CCbTXs393p7oe45nkOzXvad7H1+TC+sDd657Ld0Q/JIx9e/eWt2a9wQ3+TUncb9p7NJbs8pv3T6/Jj6LbwG+nZiJzK36ZoO7fuEfKU8XyIGvZlbWambzL5wClofWWOtprDie7p8x6INzMKahRCZp3cR8wtNdzAi7Dst5dwz07bL74e4Lei9lr2EsO7rpLU+qdZtNPfDv6x6nqdJlNB2/fMhsOzWWVZr26e8Hey7KS/V3kH1S9te6b+9HdaWvFyPQDqZ8RZbmCeIQdUvkJ4hKjZJgmmTGeMAnymPMW81YCZZrb75fMfnLhu5v2794d7NaebC9h66xGK4s7nIemk4hraMonCfWyRagAthidJX4gL15t/eUGpFTe+VpxHSNh5Si9OlzGxGkF1ALAwi2q0pV89FhNSjy8E29ZwTjzJ/tAv0golWmAL4T/hOONtDdv2lBCNSsqtiL0y84Rgtiz6yuoGqjvDuhae5hWkbPdrfnKIbxhjl+Urr5oSJwn8yR6XoA0qrS+IHb87zgyfUyu7aKQLSiKBs+I3nDhvFnYzjPq0/aVv+M4irVN7HGcM1K5VTpeUKv8ABcCVB/HgL/dHX0BE4j1AZZRUnqt0icRTUate04RfMXP7TiVBux8X5d4dus+uO312hZGqC3kGnn999YbM+v2t5bN7D7RlxUe/3wlKjKTvY7wBmY22uZZ6rsPQmfFqBB6NNXf9RjMXe3n1by6swv6GHF2UH0MsKtSw+1Pi1NPtGX5r39cjLqxB9bwjmPrvrL82pcfanxqv6jMuY+XreX5tT9XeE2m027Gwe2vpPifsJ4pqew6Tabdhw0nilmNxB2bTabTabTabTabTabTabTbs/8QAKBAAAgIBBAEDBAMBAAAAAAAAAAERMSEQQVFhcSCR8DCBofGxwdHh/9oACAEAAAE/IRpXPTLMhKVMhC/495KM87sGwKza/wACEKUj7kUEMFoPaGle7P8AD7AwqF75MBXcVGuSV14HB2M9rGP+er3uJnYdHL5ntjththytOB4oFcYZ2xt4TbyNnEHQfo0QmPSbyCThdsnI3bkQz0BOwW71gPwv7iH8XmPhmEIz7uH8Ef8AWz2F/wBOhTB8ORBsZjD+NGQAakErk6Y66cF2UfwYHyJhB3tQklHerW7MoZNdmOwefKAdFDmPse/wPyP8Rlu967Kj/bQJGvC9hgEUz9oEmEL+Wx87obauRjSW6HuLVwn5t+EaUfcSkoFOxgt1z8yDZsRwzJTHs2Wia3JXgptkmrNkXm9nncVif7nxk9Yyoa0YNJ4I4NxYJDmsPainT3+f9IRYGQkWBwCMV0fyYb2SK9N+xJu8cDjZDeRluS+8WPvYGxf0etpZKFBCIBmYx8CIijiIvI1bD0yt0mjaTnM9iE7+yKzSVNi0nmHP2glgjNEA32JSmJKAnKvKMljg3QWiLcqLI664VKUhNkmpcb/WQF3bTUyQog6NLybObIBnvx0GXJ15TZHRzqyylbkUYNnQasp2KbIDXa/9E7c9gMxWYhWUIeIlYQwp4/8AlK5CvcbJMKsJgjqpcrdCfo/0dv0K9FSIxaG4JjsZhErgMJzmkQ0E7CA5MibiRsth7tEaNS31nbSQUASDdCbLkMqb7FJA/ScokHMNuBPqAF/qtltYH94MRvCKHmbhkngEC9ASNJMxkNgtpc2ViYbzSEzq0ISJEtJqR6ipTSJgPFGYy0nYbckrnQcZtA0XGhdAyY+5kgHAmkgRAjHRDTHj1LanWmBDcBBOMCaOk5DoPCHkdZLgbN6SoQgVCQuUNpkKep36UEgkMgAzh3JLw2IihsxZsCyO84MAgQ3kQKJwHoJkuzqB/Swd/QZ5TlUSIlEBGGgY8VEJOSOgDJNjNYFbJ9DfuMSNECN9hGFAejEvW79T1apuQLgSORmDTrgLmqIXEdaXsaCZu07m5EsmtFkJAXqd+uCBg3qUu0RC022djdSLEQ4Dlh8iDkC21EKb0sBpUXrO/pNr5OJg0AtrxgYxSbyQmWx7+SFPRuBCFsCYggFi5zFeAmIQtz6kmPQ/SlTkpzBl7sQ8BjRAs5slMQ0WeLIFjF7lipIgbGDaGnAHpW2F2EnJ5LR5D7Eiv6EpLfCFOQv3EWRBkDBjOwjZ5IhZ5YlpkWeeSpIpoKGEcszm8ZKMD4evpteuXScMrAkUoxG2TMVoOAjO5hJrGyTjYaE+IYSxjEsERAywvk2J9UfRaFJHJlMhHQXgLZtQ+EsjfJu86VCaWGEihsOUsmEpMxq1YrxAiRMJnjk959IvQfqOxwY+1GyfeCxWGgbByxOzYnwcKMvJSRrHZXnBWI5E09thkjxEUPBtyyJsqh7Pt6Jekf0a5mMybaQYqpHWJFg4GWjZmQTR9gyCQwF4F/RaEwgZEqMi90JiJlyBZgqGbknIXuVBIsZJMiI/SoTqpkj0RjPkUUjWyvE/CGI854akiVH/AElhoQFMnJchhphRej4ES0xKcw5yiiKb/ISECtQfM7ENqEzif/UPBNXzgSc85mLuECmYYTd+KYsVHR9xDvI/v0jB3qpldk6PcQ3LKFJc57H9/qY/UwT5PZLvln3n/CzsKKcdw/gld0H0hTLGh4P/AEyArY9CKdrg+ENsT2/CGjCuX36lmQXQurHyX2M5UvsS2JHSN8Gec+8LKc53owj2Ku22ro0EWkmUiYGzEQlG91hKJtLeSGYTnlExLbsggvCFgQu+Bw3ORvuEsLOxYMKz0RmTUaehRpMpOew3mFnDm+03gmI/M4ZE5dQk0IpzSxsCTjoxYMqbaMmzAEXg+SV5VDbY0q6YRlmB9gTeWRjloQDQOP7o+Bn7AxoWEHoIPwfggqxnhD+wRSNdw+Ri/cNn/I7WSh+kQ79cHnwDnr8nwMcH+j52fOyCfiZ8TP25h0nlPxM/anwsgMH/2gAMAwAAARECEQAAECDPx7KHCHNI80CCNOEmCEIIDFPMH65DPHKBpfHuRRKjLrhIgvQqIbf33PfPWrPmBvvLJwVVHLr27d+n7f8AHv3QFF3vRR307z6zSDzCoEEU4/O7b3fYR+LoJQG20EZut3p2/shkyUpnmqbO9wpc23zwp5Sj/wA8t9N5eq4x9GR0iuv9WxR0P1w4Xo8aFdW8vS78+ZMdUoC6WJ9E+UxvvYDsxe6td6AqZ//EAB8RAAICAgMBAQEAAAAAAAAAAAABETEQISBRYUFxMP/aAAgBAhEBPxDCgNzzTaG543ZVMSHzQ3L43cFhJxRYbLBT5a7gvg2wUFQNTJSSnEifRPou4jCSI+CCEXER1gRBCIRb+5TgbGILIJLNeiCkaJOw0tCyFWbf3jcYm9s3bEsa0UHkTYqzb+8WMRLLIb9IgsFxJQ2M8SYmps8FZCpYnYbjBQcHD6MO+N2W4NmWYTRLZN0aDb5XZW3hTpRAmXwkyxBaI3Y3PK7Mkx6Nx4tmMbHpL/hcexLPY9TvHsdo7x9Jnsex7Hsex7Htj//EACARAQEBAAMBAAIDAQAAAAAAAAEAERAhMSAwYUFRcaH/2gAIAQERAT8Q4QYA+xo/N95WT3h4x5RgQ7+X3nxxeueQ3D9ivvya3g6RVaXVDhL+b9l+yXvkS7h3PJ1erWW5bvA8ujxvwmwBu/fCVcCSHuS9xCWR/BtkJO4EmAlSHuXB9ZP4FkuRdf6krJhL5M+zyBr4C1QWgL3sz/aeJ5+X3kJZl7tlkLPvd7w5ny+8DY54z22QzxhdjsmdgEY+n3jTu/5QFyXBMa8ALn4H21kyvBWsm292tra2tra2vH//xAAoEAEAAgECBAYDAQEAAAAAAAABABEhMUEQUWGxIHGBkaHRwfDx4TD/2gAIAQAAAT8QZIndUD7hkJ49BnirS1SEQKqSrMaxf0SiB6WoMUksNgchKyOkJjQCFYkZfUCyEHzUlyoziClKcdc8st4Juh0GOpxZ7IAqlI7IybWC1fyl8WiRGg1CqjziEGoR2QFBjXGgtLAqxk3FhVHVYDUkmGW4jStoiuJDrIOrMDf4i/Lg3RshDuVTmpk+SSWN6UvOXgwj/wBBzn4DvH58wXAAXIszT1FrGfEHz/zAecYeof4mrad0nbeUv8XFz+p1nHJII4dpjrnJR2gvZPzOrB/GEt6wHQsKmSpGtFscmF35f6EmJlLunVixpyFS25DvnseoJpjaxHYesJsp6G3uRlQG6E0j9wTntAgGR/W0nnAhPcd2JDGdSBkAmWoTqYW0uzKr+AyuXgAuawhr0OdDEWCS+UXYml1cxpwCOQdUorJZdiDplwkFDUFBSeIbLZSRI0LUADM1o1Fslb2osqo5ZKTgsxMA++8sp4WwlIIVzOXUzsDAasjLHJlFYYt15pM4qcAzX3QhVvnfZ8EReMkCo/mMjjMZxvoj6IASA8wm6LT4dx3fBXCCTJBQSI11Hj9cpWU3f7TKgYMBUmJBpWrMa4lFAJYE0n4l7PMC7EIGJKYVLm77lEW46nNWRVIL6EsBVY1XZTcriFoZoEwHIGwzLxLLui47YQTk5W1Bx7Q9GQ0h1Ff8O47vElRcJTW1ADtK6RE36yYkq539E0NUPaDLnuNQHKWYnRIjziX6lSuLKnTCebcpLdnVBKLQwI76xWjIJjrh0oBCkCuZldzyoSmkO2U58FSI2CnmKKiAc5McznoGrr/w7ju8NSpXDWY5uDD1WdIw3yNe9AjhqTqNfOkeidATXK2GnnOwBLCh8fidJ6EWz6zwYSgQmDD/AMr3Hdi8WKRhwHlDyylq5yXfpNJL5CiYBlhq3mk160Dq7LNyVzGbT5R6E1vwIJgffiQeM8Xcd2VwuPhvLhH7qVAMdPKvjlOfGwlz7ytT0jM1lS2ubTwzbDvl4mV5hCyvGAOCPc6HAYM+UC+/geMiRmg2pUVczw8VI1HiqOdrD4NBmZkajo4HPhNTClY6BKRkr4HwJ1SpQ1Vb32gyYWMxdYsso93sTWCvc8+EjOsudwfyQgOEzNHRIfAUyQJTx1vAx5cdilqd7EwL/LkjFC5rLrwq3R0IY6x0faXAxD8CnVE5LcYhooZeqj0IozSggeHW8Lw2mEREGOqYksOCIuw+suybFTdTBOYJsKcS9RmdRyRKDn8JdLhWI64uOFxXAiHh1v8AjuFiTo7zbU5kdrSN6NW6ze9z2LYxwRgMEZ5NkGK5tSegzLlSdYmcGWGIE0MM6mafBcua3iTgeAVQgMRJpMw43A+HWaYcgxwOCgcbCLQjlHvBjnNzBw7y5g8M0R8OtwqVwXwGkf5q5qE5eL1d2pWKOC+R6CDnDd6wjjqmoRyAdZdXARLnXBCos8AUODPSekvlAy/EjhUWLHRW0BqQbVFrD1uErQe+nqio032T0lDlK2hpkWukzIyobeAeHOSMvCnUC4cWPAlCQq9rcr0C2e7u5brFESkRNBuMRC9qa1pCgl5PqecYX0Q8ny0nSKecvrY1IWF0mntNQ6OEBwOFy4MWXO47vCcGVA4cnnmMI5Q90yi03yQxDKa1rpKnqIwA5jPgCNe8xQq0a+rMI+ea8qMcnd9zlhGCkHEIwiokZ3Hdh4BOsoLfoz6jdg2iKFQ+apn5hk9TT4MZOpqrXGZhSuAH0DlF2F+WKvtD8MOoPppNM87iGCXnEQcVUThd53YS5fDM2TnL/CbSbZtfOZcxmyh/QcKv0MwqVgobsyxgNCoTSFNjWfHnLnd8q1hHkwjpMPwSMBcCMh5zWiSuAHgs+A92BwGuH+RBpNBqKq5X4O5wTSQmMkjQsmIV87I7hzi2wudktgm2TLEMEqQDZpjKy0eayhLZpNUJg+zulXFJOWVBiYgbMPKaR62zBaNzAaBmwpgJNsPcjlSokCfJ93gWEOjrE6GQp85cdLuocEK2bUMmhkO8hlhvNb9ZzGNIcxGXKaXQzhveZ1rQowxnDgnXLhgRFpWGYPVjLhWvYlyKx2DHPyF8VNjyJogD2jkaZDFLQLvAnONElH2v8x4MekIrdXUxFEhfaEqDSVxnoB7vH4JL1a80f5ozTqsAoQTa2EoXd9ncprHx+jCfN34MRfmVXxIcrUlIJt+bJQtQgqlGZjd+moD7BylWSKX8afuNb3/BjwBPOFmuQc5nKnDHOqbGWxtVvVPmJ/n1O8vmY0lHOoYABmh60tCmObVU8iQMrmmJABAE1YPSsQIs0iG5PcfdhwWsgz21mTL3TzmpokguyJ6CxzE5pS3d3M5rUC0VbNJrvlQhdEKpoyUZQW7TLLuRXA21WHS9BQeVuI1Mirz5EZjKQhsKPIsF7sLw3Nebk0YU2XnAE0D1rXN1YJdDC8qwazdQcsxjvAhsANEXuqss1qcnJqyLLAGCRago2hbLy1GVRttG22CqpJAE6rnKwPVqyG2GngEhu9nCtS7uoMmawLQotGOCHMhwEL6D3Z/Vfcf7E/uJhdEvFGkXbqS1zktoLMH1TKH0E20lt38zP1Kf2kX9qXue93ld/V7RcCa0A+JrOY/36fsU/wBwn6l9x/qfc257s/SvufpX3P6T7hsXuzl2vNnLPdn719z+4+4cn7vuaYaT/9k='

INSERT INTO [dbo].[Chat]
([ChatUser]
,[ChatMsg]
,[ChatDataHora]
,[ChatOcultar]
,[Foto])
VALUES
('VILANI'
,'Opa!!!'
,GETDATE()
,0
,(select cast(N'' as xml).value('xs:base64Binary(sql:variable("@str"))', 'varbinary(max)')))
GO
Registered member
2 messages
Popularité : +1 (1 vote)
Posted on May, 01 2017 - 6:41 PM
Outro dia tentei gravar uma imagem num banco de dados mysql e não tive sucesso, tb não uso analise, tentei usar da forma acima (BULK N'"+ "e:\uploads\" + TABLE_fiscal.NomeArquivo + "' , SINGLE_BLOB) mais não deu erro de sintaxe, alguém poderia passar a sintaxe para mim.

Obrigado
Message modified, May, 01 2017 - 6:42 PM
Posted on May, 10 2017 - 4:57 PM
Consegui ! Obrigado a quem colaborou aí...
Usei HADD mesmo.

ARQUIVO.ACESSADO = "0"
ARQUIVO.DATACADASTRO = SysDateTime()
ARQUIVO.IDENTIFICADOR =gsIdentificador
ARQUIVO.MIMETYPE = NOMETABELA.MimeType
ARQUIVO.NOMEARQUIVO=NOMETABELA.NomeArquivo
ARQUIVO.TAMANHO=NOMETABELA.Tamanho
//ARQUIVO.CONTEUDO = NOMETABELA.Caminho -> aqui eu referenciava o caminho da imagem(nao funcionava)

HLinkMemo(ARQUIVO, ARQUIVO.CONTEUDO, NOMETABELA.Caminho, hMemoImg) ->desta forma funcionou

ScreenToFile()
HAdd(ARQUIVO)